Major NTSB investigations
4 cases where the first occurrence was “Loss of engine power(partial) - nonmechanical”.
Cases per year
| 1982 | 1 |
|---|---|
| 1984 | 2 |
| 1987 | 1 |
Where
Open the mapLatest cases
Query with SQL
duckdb -csv -c "SELECT c.\"ntsbNumber\", c.\"eventDate\", c.\"eventType\", c.\"eventCity\", c.\"eventStateOrRegion\", a.n_number, a.\"aircraftMake\", a.\"aircraftModel\", c.\"highestInjuryLevel\", c.\"totalFatal\", c.\"completionStatus\", c.report_url
FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c.\"mKey\" AND a.position = 1
WHERE (c.board_report_url IS NOT NULL OR c.\"investigationClass\" = 'Class 1' OR c.\"caseType\" = 'Major - Launch')
AND c.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 354)
ORDER BY c.\"eventDate\" DESC, c.\"ntsbNumber\" DESC"Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT c."ntsbNumber", c."eventDate", c."eventType", c."eventCity", c."eventStateOrRegion", a.n_number, a."aircraftMake", a."aircraftModel", c."highestInjuryLevel", c."totalFatal", c."completionStatus", c.report_url FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c."mKey" AND a.position = 1 WHERE (c.board_report_url IS NOT NULL OR c."investigationClass" = 'Class 1' OR c."caseType" = 'Major - Launch') AND c."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 354) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB DCA87MA033Accident · Serious injuriesMajor investigationFinal reportBritish Aerospace 3101 · Kenner, LAThe acft overran the dept end of the rwy and came to rest on a hiway barrier after an aborted takeoff following engine torque oscillations. The capt tried reducing the power levers as he had been taught to 'get off' the ttl since he thought the ttl was…NTSB DCA84AA033Accident · 9 fatalFinal reportBritten-Norman BN-2A Islander · Vieques, PRA witness reported he heard an apparent eng problem after the acft took off & began a left turn for a x-wind departure. Reportedly, the acft oscillated, then after regaining some lost alt, it banked abruptly to the left, nosed down, & subsequently, crashed in…NTSB CHI84MA249Accident · 4 fatalMajor investigationFinal reportCessna 340A · Cincinnati, OHPlt requested fuel from FBO but failed to make it clear what type he wanted. The FBO personnel misunderstood the plt's request and refueled the acft with 'jet a' instead of aviation grade gasoline. The plt did not monitor the refueling process and failed to…NTSB DCA82AA015Accident · Minor injuriesFinal reportNihon YS-11A · King Salmon, AKThe acft was on a scheduled flt from anchorage to cold bay, AK with intermediate stops at King Salmon & dutch harbor, AK. En route between anchorage & King Salmon, the air temps at cruise altitude were between -36 & -40 deg fahrenheit. While entering donwnd…