Fatal NTSB investigations, MA
4 cases where the first occurrence was “Loss of engine power(total) - mech failure/malf”.
Cases per year
| 1984 | 1 |
|---|---|
| 1990 | 1 |
| 1991 | 1 |
| 1996 | 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\" = 'MA' 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\" = 351)
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" = 'MA' 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" = 351) 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 IAD96FA055Accident · 4 fatalField investigationFinal reportPiper PA-28R-200 · Wareham, MALoss of engine power due to bearing insert being destroyed by excess heat. A factor in this accident is the pilot's experience level.NTSB NYC91FA178Accident · 2 fatalField investigationFinal reportPiper PA-32RT-300T · Yarmouth, MAThe failure of the number one cylinder fuel injector line due to fatigue cracking induced by corrosion and propagated by cyclic loading which resulted in a total loss of engine power. The corrosion was due to the manufacturer's process of brazing the metal…NTSB NYC90FA199Accident · 3 fatalField investigationFinal reportPiper PA-31T2 · Mattapan, MAThe pilot's improper in-flight planning/decision, which resulted in his failure to maintain control of the aircraft. Factors related to the accident were: failure of the left fuel control unit, and the adverse weather conditions.NTSB NYC84FA072Accident · 1 fatalField investigationFinal reportCessna 152 · Barre, MAThe acft was landed off the arpt tailing fire and smoke shortly after takeoff. It was a cold day and the CFI and student had trouble starting the acft even after pre-heat was used. Witnesses saw the acft after takeoff descending withsmoke and flames trailing…