NTSB investigations, 2018
6 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\") = 2018
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") = 2018 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 CEN19LA016Accident · No injuriesClass 3 · LimitedFinal reportRotorway 162 · Passaic, MOThe electrical short in the main rotor rpm indicating unit which provided an inaccurate indication to the student pilot and resulted in substantial damage during the precautionary autorotation.NTSB DCA18WA302Incident · No injuriesForeign investigationBoeing 737 · Edinburgh, United KingdomThe Air Accidents Investigation Branch (AAIB) of United Kingdom has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on September 10, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of…NTSB WPR18FA218Accident · 2 fatalField investigationFinal reportMooney M20K · Baker City, ORThe pilot's exceedance of the airplane's critical angle of attack during the landing approach as a result of his diversion of attention after a series of non-essential aircraft systems became inoperative following the failure of the engine-driven vacuum pump,…NTSB GAA18CA407Accident · No injuriesData collectionFinal reportBeech 58 · Mackinac Island, MIThe pilot’s failure to remove the pitot tube cover during the preflight inspection, which resulted in his delayed decision to reject the takeoff with insufficient runway remaining to safely stop the airplane.NTSB DCA18WA157Incident · No injuriesForeign investigationBoeing 737 · Lahore, PakistanThe Pakistan Safety Investigation Board has notified the NTSB of an incident involving a BOEING 737 airplane that occurred on April 11, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Pakistan's investigation under…NTSB ENG18WA013Incident · No injuriesForeign investigationBoeing 737-800 · Paris, FranceThe Bureau d'Enquêtes et d'Analyses pour la sécurité de l'aviation civile (BEA) of France has notified the NTSB of an accident involving a Boeing 737-800, which occurred on February 8, 2018. The NTSB has appointed a U.S. Accredited Representative to assist…