NTSB investigations, 2022, ID
8 cases where the sequence of events included Loss of control in flight.
Cases per year
| 2008 | 4 |
|---|---|
| 2009 | 4 |
| 2010 | 5 |
| 2011 | 6 |
| 2012 | 5 |
| 2013 | 4 |
| 2014 | 7 |
| 2015 | 2 |
| 2017 | 7 |
| 2018 | 5 |
| 2019 | 3 |
| 2020 | 4 |
| 2021 | 3 |
| 2022 | 8 |
| 2023 | 4 |
| 2024 | 2 |
| 2025 | 4 |
| 2026 | 3 |
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\") = 2022
AND c.\"eventStateOrRegion\" = 'ID' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '240' 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") = 2022 AND c."eventStateOrRegion" = 'ID' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '240' 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 WPR22LA362Accident · No injuriesClass 4 · LimitedFinal reportAngus Watt Zenair Stolch 750 · Howe, IDThe pilot’s failure to maintain adequate airspeed during the landing approach, which resulted in an aerodynamic stall.NTSB WPR22FA347Accident · 2 fatalClass 3 · FieldFinal reportSkiles Kenneth C RV-6A · Preston, IDThe non-instrument-rated pilot’s continued visual flight into instrument meteorological conditions, which resulted in a loss of control due to spatial disorientation.NTSB WPR22LA328Accident · No injuriesClass 4 · LimitedFinal reportFall Martin Super CUB · Stanley, IDThe pilot’s failure to maintain airplane control during takeoff with a crosswind.NTSB WPR22FA304Accident · 2 fatalClass 3 · FieldFinal reportAviat A-1A · Yellow Pine, IDThe pilot's failure to maintain adequate airspeed during an initial climb, which resulted in the exceedance of the critical angle of attack, subsequent aerodynamic stall, and impact with terrain. Contributing was the pilot’s decision to operate the airplane…NTSB CEN22FA331Accident · 2 fatalClass 3 · FieldFinal reportColumbia Helicopters CH-47D · North Fork, IDThe failure of the flight crew to properly secure a company-issued iPad, leading to its migration into and jamming of the copilot’s left pedal, preventing the pilot from arresting a left yaw, and resulting in a loss of control.NTSB WPR22LA207Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 175 · Blackfoot, IDThe pilot’s loss of airplane control during the landing approach which, resulted in an undershoot and collision with a fence.NTSB WPR22FA173Accident · 2 fatalClass 3 · FieldFinal reportBlue Side UP Comp AIR 8 SS52 · Grasmere, IDThe pilot’s failure to maintain proper airspeed and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall.NTSB WPR22LA132Accident · Minor injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Howe, IDThe pilot’s failure to maintain adequate rotor rpm while descending with a gusting tailwind condition, which resulted in a loss of helicopter control.