NTSB investigations, 2021
9 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\") = 2021
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") = 2021 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 ERA22LA035Accident · No injuriesClass 4 · LimitedFinal reportPiper PA46 · Immokalee, FLThe flight instructor’s delayed remedial action which resulted in the airplane impacting terrain short of the runway.NTSB ERA22LA006Accident · No injuriesClass 4 · LimitedFinal reportCessna 172K · Williston, FLThe pilot’s failure to maintain clearance from terrain on approach which resulted in controlled flight into trees. Contributing to the accident was the flight instructor’s inadequate supervision of the approach path, the dark night conditions and the landing…NTSB CEN21LA471Accident · Serious injuriesClass 4 · LimitedFinal reportJust Highlander · West Cobb, ARThe airplane’s encounter with gusting wind conditions and low-level wind shear on final approach, which resulted in a loss of control, an aerodynamic stall, and a subsequent hard landing.NTSB ERA21LA330Accident · No injuriesClass 4 · LimitedFinal reportSchweizer SGS 2-33A · North Springfield, VTThe check pilot's failure to account for the extended departure distance from the airport during a simulated tow rope break and recovery.NTSB CEN21FA345Accident · 1 fatalClass 3 · FieldFinal reportPiper J3C-65 · Hartford, WIThe flight crew’s exceedance of the airplane’s critical angle of attack during a simulated engine failure during initial climb after takeoff, which led to an aerodynamic stall/spin and loss of control. Contributing to the severity of the occupants’ injuries…NTSB WPR21FA288Accident · 1 fatalClass 3 · FieldFinal reportBorom Long-EZ · Tucson, AZThe pilot's failure to maintain adequate airspeed and to retract the speed brake during the approach, which resulted in a hard landing short of the runway. Contributing to the accident was the flight instructor’s decision to conduct a flight review in an…NTSB CEN21LA226Accident · Serious injuriesClass 4 · LimitedFinal reportI.C.A.-Brasov IS-28B2 · Hampshire, ILThe flight instructor’s failure to maintain aircraft control resulting in the exceedance of the glider’s critical angle of attack following the breakage of the weak/safety link during a winch launch, which resulted in an aerodynamic stall and spin, and…NTSB WPR21LA183Accident · No injuriesClass 4 · LimitedFinal reportMD Helicopters 369FF · Mesa, AZA tail rotor blade strike to an undetermined object while practicing approaches to unimproved terrain.NTSB CEN21LA118Accident · No injuriesClass 4 · LimitedFinal reportBeech 300 · Davenport, IAThe pilot’s failure to maintain directional control of the airplane, and the flight instructor’s inadequate oversight during a simulated engine out takeoff that resulted in a runway excursion and impact with a snowbank.