NTSB investigations, 2009
8 cases where the sequence of events included Flight instrument malf/fail.
Cases per year
| 2008 | 2 |
|---|---|
| 2009 | 8 |
| 2010 | 2 |
| 2011 | 1 |
| 2012 | 2 |
| 2013 | 1 |
| 2014 | 5 |
| 2015 | 2 |
| 2016 | 1 |
| 2017 | 3 |
| 2018 | 6 |
| 2019 | 4 |
| 2020 | 3 |
| 2021 | 3 |
| 2022 | 4 |
| 2023 | 3 |
| 2024 | 2 |
| 2025 | 4 |
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\") = 2009
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '334' 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") = 2009 AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '334' 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 CEN10LA068Accident · No injuriesLimited investigationFinal reportBeech V35 · Dodge City, KSThe failure of the pitot heat system in icing conditions resulting in an inoperative airspeed indicator which led to an inadvertant stall while on final approach. Contributing to the accident was the pilot's decision to fly into known icing conditions.NTSB ERA09FA376Accident · 4 fatalField investigationFinal reportPilatus PC-12/45 · Raphine, VAThe pilot's failure to maintain control of the airplane while in instrument meteorological conditions following a reported instrumentation failure for undetermined reasons.NTSB DCA09IA064Incident · No injuriesIncident investigationFinal reportAirbus A330-323 · Kagoshima, JapanBrief and temporary blockage of the pitot probes in cruise flight, most likely due to ice crystals aloft, leading to erroneous airspeed indications and airplane automation degradation as designed. Contributing to the incidents were design features of the…NTSB ERA09CA333Accident · No injuriesData collectionFinal reportChatham Robert M RV6-A · Gilbert, SCThe pilot’s failure to maintain directional control of the airplane during landing roll. Contributing to the accident was the airspeed indicator that became inoperative during the landing approach.NTSB CEN09CA342Accident · No injuriesData collectionFinal reportBeech S35 · Decatur, TXBoth pilots' inadequate preflight inspection and failure to identify the presence of dirt and insect larvae in the pitot tube, and the owner-pilot's attempt to turn off the runway and onto the taxiway at an excessive speed during the aborted takeoff.NTSB DCA09IA055Incident · No injuriesIncident investigationFinal reportAirbus A330 · Los Cayes, HaitiThe final report for this incident was combined with and can be found under NTSB Investigation number, DCA09IA064.NTSB CEN09LA281Accident · No injuriesLimited investigationFinal reportCessna 551 · Stillwater, OKThe pilot's loss of control for undetermined reasons.NTSB CEN09LA276Accident · Serious injuriesLimited investigationFinal reportHawkins August E Aventura II · Griffith, INThe pilot's failure to maintain control of the airplane due to an inadvertent stall. Contributing to the accident was the failure of the airspeed indicator due to separation of the pitot-static line at the left wing root.