NTSB investigations, 2011
14 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\") = 2011
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") = 2011 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 WPR12CA056Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Waipahu, HIThe certified flight instructor's delayed remedial action and inadequate supervision during a practice autorotation. Contributing to the accident was the student pilot's excessive application of the throttle.NTSB WPR12LA027Accident · No injuriesLimited investigationFinal reportBeech A36 · Yucca Valley, CAA loss of engine power for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB WPR12CA008Accident · No injuriesData collectionFinal reportCessna 172P · Cornelius, ORThe airplane’s encounter with an unseen hole or obstacle on the grass runway.NTSB ERA11LA481Accident · Minor injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · St. Petersburg, FLThe commercial pilot's improper recovery from a practice autorotation, resulting in a tailboom strike and subsequent rollover.NTSB ERA11CA474Accident · Minor injuriesData collectionFinal reportSchweizer 269C-1 · Titusville, FLThe student pilot's landing at an unapproved location, which resulted in a ground fire from the engine exhaust.NTSB WPR11LA317Accident · 1 fatalLimited investigationFinal reportSchweizer SGS 2-32 · Bigfork, MTThe pilot’s failure to maintain adequate airspeed and his excessive control inputs during a simulated rope break while taking off, which resulted in an accelerated aerodynamic stall.NTSB ERA11FA354Accident · 2 fatalField investigationFinal reportBeech C24R · Valparaiso, FLThe pilots’ failure to maintain airspeed, which resulted in an inadvertent, low altitude aerodynamic stall.NTSB WPR11TA274Accident · No injuriesFinal reportBell 206B · Franklin, CAThe student pilot's failure to maintain rotor rpm during the practice autorotation.NTSB CEN11LA373Accident · No injuriesLimited investigationFinal reportMooney M20R · Lake In The Hills, ILThe pilot's improper landing flare and recovery from a bounced landing, which resulted in a loss of control. Contributing to the accident was the certified flight instructor’s inadequate supervision.NTSB DCA11MA076Accident · 4 fatalClass 1 · MajorFinal reportGulfstream GVI · Roswell, NMThe National Transportation Safety Board determines the probable cause(s) of this accident as follows: an aerodynamic stall and subsequent uncommanded roll during a one engine-inoperative takeoff flight test, which were the result of (1) Gulfstream’s failure…NTSB ERA11CA205Accident · Minor injuriesData collectionFinal reportCessna 172M · Statesville, NCThe certified flight instructor's inadequate remedial action during the go-around, which resulted in a collision with trees.NTSB ERA11CA201Accident · No injuriesData collectionFinal reportSchweizer 269C-1 · Mount Pocono, PAThe flight instructor's selection of an unsuitable landing site to practice autorotations, which resulted in an inadvertent dynamic rollover during touchdown.NTSB WPR11GA144Accident · Minor injuriesFinal reportEurocopter AS 350 B2 · Riverside, CAThe failure of both pilots to follow proper procedures during a simulated hydraulic emergency that resulted in a loss of helicopter control. Contributing to the accident was the flight instructor’s delayed remedial action.NTSB ERA11CA162Accident · No injuriesData collectionFinal reportBell 206 · Ridgeland, SCThe certified flight instructor's delayed remedial action during a practice autorotation, which resulted in a hard landing.