NTSB investigations, 2018
4 cases where NTSB found Indicating/recording systems.
Cases per year
| 2008 | 1 |
|---|---|
| 2009 | 9 |
| 2010 | 8 |
| 2011 | 4 |
| 2012 | 2 |
| 2013 | 5 |
| 2014 | 5 |
| 2015 | 5 |
| 2016 | 4 |
| 2017 | 7 |
| 2018 | 4 |
| 2019 | 7 |
| 2020 | 3 |
| 2021 | 2 |
| 2022 | 2 |
| 2023 | 6 |
| 2024 | 5 |
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 year(c.\"eventDate\") = 2018
AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '010231'))
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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '010231')) 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 WPR19FA022Accident · 4 fatalClass 2 · FieldFinal reportPiper PA28 · Guthrie Center, IAPilot incapacitation due to carbon monoxide poisoning as a result of an undetected crack in an engine exhaust muffler, which permitted entry of exhaust gasses into the cabin via the cabin heat system.NTSB CEN19CA017Accident · No injuriesData collectionFinal reportPiper PA28R · Hobbs, NMThe pilot's incorrect altimeter setting during the night visual approach, which resulted in a controlled flight into terrain.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 DCA18CA283Accident · No injuriesClass 4 · Data collectionFinal reportAirbus A321-271N · Los Angeles, CAa tailstrike caused by inappropriate recovery technique after a bounced landing. Contributing to the accident was the failure of the radio altimeter, caused by the approach being over calm/flat water, that was not recognized by the flight crew.