Fatal NTSB investigations, LA
5 cases where the first occurrence was “Loss of engine power(total) - nonmechanical”.
Cases per year
| 1984 | 1 |
|---|---|
| 1988 | 1 |
| 1991 | 1 |
| 1992 | 1 |
| 1997 | 1 |
Where
Latest 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.\"eventStateOrRegion\" = 'LA' AND c.\"eventCountry\" = 'USA'
AND c.\"highestInjuryLevel\" = 'Fatal'
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\" = 353)
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."eventStateOrRegion" = 'LA' AND c."eventCountry" = 'USA' AND c."highestInjuryLevel" = 'Fatal' 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" = 353) 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 FTW97FA269Accident · 1 fatalField investigationFinal reportMooney M20C · Sarepta, LAThe pilot's impairment (drugs) resulting in his becoming disoriented and the ensuing loss of engine power due to fuel exhaustion. Factors were the lack of suitable terrain for the forced landing and the inaccurate navigation chart.NTSB FTW93FA008Accident · 1 fatalField investigationFinal reportBeech 95-B55B · Chatham, LAThe inadvertent stall and spin. Factors were the power loss due to fuel starvation, the dark night, and his failure to use the boost pump for engine restart.NTSB FTW91FA028Accident · 2 fatalField investigationFinal reportFolland Gnat T-1 · Bossier City, LAImproper planning/decision by the pilot and his delay in diverting to an alternate airport, which resulted in fuel exhaustion due to lack of fuel. The adverse weather conditions and radio malfunction were related factors.NTSB FTW88FA136Accident · 3 fatalField investigationFinal reportDouglas DC-6A · Golden Meadow, LAAfter abt 4.3 hrs on an overwater flt, the crew rprtd they had 15 min of fuel remaining. Subsequently, 3 of 4 engs lost pwr fm fuel exhaustion. Drg an emerg lndg, the acft hit a levee & was extensively dmgd. Most of the wreckage came to rest in a dainage…NTSB FTW85FA060Accident · 1 fatalField investigationFinal reportCessna 172A · Hammond, LANon-stop endurance for this make/model is 4.2 hrs in normal cruise. Calculated ete for plt's reported route of flight is 4.0 hrs (non-stop, no wind, normal cruise). Time from intial departure to mishap was 6.0 hrs. Acft of this discription was observed to…