NTSB investigations, 2013
11 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\") = 2013
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") = 2013 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 ERA14CA080Accident · Minor injuriesData collectionFinal reportSchweizer 269C · White Plains, NYThe flight instructor's failure to maintain airspeed during a practice autorotation, which resulted in a hard landing and subsequent loss of controlNTSB ERA14CA040Accident · No injuriesData collectionFinal reportBeech E 55 · Blountville, TNThe pilot's delayed reaction and loss of directional control while performing a simulated engine failure during the takeoff roll. A factor in the accident was the CFI's delayed reaction to the loss of directional control.NTSB ERA14CA023Accident · No injuriesData collectionFinal reportCessna 182Q · Wauchula, FLThe pilot's improper landing flare which resulted in a hard landing.NTSB ERA13CA426Accident · Serious injuriesData collectionFinal reportMarconi Fred I JR Velocity XL/RG · Pahokee, FLThe pilot's failure to ensure that the landing gear were extended during the simulated forced landing attempt. Contributing to the outcome was the pilot's decision to continue the aborted landing after the propeller had contacted the runway.NTSB ERA13LA300Accident · Minor injuriesLimited investigationFinal reportSikorsky 269C · Lumberton, NJThe pilot's movement of the throttle to the idle detent at the beginning of a practice autorotation, which was contrary to procedures and resulted in the engine hesitating during the power recovery and a subsequent hard landing.NTSB ERA13LA257Accident · No injuriesLimited investigationFinal reportCessna 180J · Greenwood, MSA partial loss of engine power due to carburetor icing.NTSB WPR13CA253Accident · No injuriesData collectionFinal reportSchweizer 300C · Hamilton, MTThe student pilot’s failure to maintain helicopter control during a practice autorotation and the flight instructor's delayed remedial action.NTSB ERA13CA230Accident · No injuriesData collectionFinal reportCessna 152 · Americus, GAThe pilot’s delayed decision to terminate the practice approach during a simulated loss of engine power maneuver, which resulted in an inadvertent collision with utility wires.NTSB WPR13TA198Accident · No injuriesFinal reportBell OH-58C · Phoenix, AZThe pilot receiving instruction's delay in adding power during a recovery from a practice autorotation.NTSB CEN13CA207Accident · No injuriesData collectionFinal reportBeech A36 · Fort Stockton, TXThe student pilot inadvertently switching the fuel selector to the OFF position and the flight instructor's failure to monitor the student pilot's actions.NTSB WPR13LA082Accident · No injuriesLimited investigationFinal reportPiper PA-60-602P · North Las Vegas, NVThe pilot’s failure to maintain an adequate descent rate while on final approach, which resulted in a hard landing and landing gear collapse due to overload following the failure of both engines to respond to power inputs during an attempted go-around for…