NTSB investigations, 2010
6 cases where the sequence of events included Simulated/training event.
Cases per year
| 2008 | 14 |
|---|---|
| 2009 | 25 |
| 2010 | 6 |
| 2011 | 14 |
| 2012 | 10 |
| 2013 | 11 |
| 2014 | 11 |
| 2015 | 12 |
| 2016 | 14 |
| 2017 | 7 |
| 2018 | 3 |
| 2019 | 7 |
| 2020 | 1 |
| 2021 | 9 |
| 2022 | 5 |
| 2023 | 6 |
| 2024 | 5 |
| 2025 | 7 |
| 2026 | 6 |
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\") = 2010
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '600' 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") = 2010 AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '600' 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 CEN11CA026Accident · No injuriesData collectionFinal reportCessna 180 · Farmington, NMThe failure of the pilot and the flight instructor to maintain directional control of the airplane during a training maneuver.NTSB ERA10LA302Accident · 1 fatalLimited investigationFinal reportBeech 60 · Edenton, NCThe flight instructor’s initiation of a simulated single engine scenario at or below the airplane’s minimum single engine control speed, resulting in a loss of airplane control. Contributing to the accident was the flight instructor’s failure to set full…NTSB WPR10CA270Accident · No injuriesData collectionFinal reportBeech C24R · Boise, IDThe pilot's failure to properly configure the landing gear for landing and the flight instructor's inadequate supervision.NTSB CEN10CA197Accident · No injuriesData collectionFinal reportAmerican Champion 7GCAA · Creve Couer, MOThe pilot's failure to go-around during a simulated engine failure and the instructor pilot's delay in remedial actions.NTSB ERA10CA220Accident · Minor injuriesData collectionFinal reportCessna 150G · Cooperstown, NYA partial loss of engine power during a simulated engine-out demonstration due to carburetor icing.NTSB ERA10LA162Accident · Serious injuriesLimited investigationFinal reportPiper PA-34-200T · Vero Beach, FLThe certified flight instructor's failure to monitor the airspeed while the student performed a single-engine approach.