NTSB investigations, 2014, TX
7 cases where the sequence of events included Powerplant sys/comp malf/fail.
Cases per year
| 2008 | 5 |
|---|---|
| 2009 | 3 |
| 2010 | 3 |
| 2011 | 1 |
| 2012 | 3 |
| 2013 | 3 |
| 2014 | 7 |
| 2015 | 2 |
| 2016 | 5 |
| 2017 | 3 |
| 2018 | 2 |
| 2019 | 3 |
| 2020 | 4 |
| 2022 | 7 |
| 2023 | 5 |
| 2024 | 4 |
| 2025 | 3 |
| 2026 | 3 |
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 year(c.\"eventDate\") = 2014
AND c.\"eventStateOrRegion\" = 'TX' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '340' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
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 year(c."eventDate") = 2014 AND c."eventStateOrRegion" = 'TX' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '340' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 CEN15FA056Accident · 1 fatalField investigationFinal reportAero Commander 500A · McDade, TXThe pilot's failure to maintain adequate airspeed and his exceedance of the airplane's critical angle-of-attack for reasons that could not be determined based on the available evidence, which resulted in an aerodynamic stall/spin. Contributing to the accident…NTSB CEN15LA042Accident · Minor injuriesLimited investigationFinal reportMosier Robert S Mosquito XET · Angleton, TXThe pilot’s failure to maintain adequate clearance from trees during a precautionary landing. Contributing to the accident was the pilot’s inadequate preflight inspection during which he failed to detect a loose drive belt, which resulted in an in-flight…NTSB CEN14CA380Accident · No injuriesData collectionFinal reportDantonio 404 · Wichita Falls, TXThe separation of a spark plug wire resulting in a loss of engine power during climb out and a subsequent forced landing on a field containing trees.NTSB CEN14LA312Accident · No injuriesLimited investigationFinal reportAirbus Helicopters AS-350B2 · Texarkana, TXThe failure of the two fuel control unit drive bearings for reasons that could not be determined based on the available evidence, which resulted in an uncommanded engine acceleration and subsequent overspeed condition. Contributing to the accident was the…NTSB ENG14IA013Incident · No injuriesIncident investigationFinal reportRaytheon 400A · Sugar Land, TXThe probable cause of the uncontained No. 2 engine failure on the Raytheon Beechjet 400A was a yellow-crowned night-heron birdstrike that resulted in fan blade contact with the inlet case and rub induced excitation of a previously unidentified natural…NTSB CEN14LA174Accident · No injuriesLimited investigationFinal reportBell 47G 3B · Oglesby, TXMaintenance personnel’s failure to safety wire the throttle control adapter per maintenance instructions when the carburetor was replaced and to detect that the adapter was not safety wired during the annual inspection, which resulted in the throttle control…NTSB CEN14FA143Accident · 1 fatalField investigationFinal reportHawker SEA Fury ISS 25 · Breckenridge, TXThe pilot’s inadequate emergency response to a runaway propeller and his failure to maintain airspeed, which resulted in the airplane exceeding its critical angle-of-attack and stalling. The cause of the runaway propeller was undetermined.