NTSB investigations, ID
15 cases where NTSB found Experience/knowledge.
Cases per year
| 2008 | 1 |
|---|---|
| 2009 | 2 |
| 2011 | 3 |
| 2012 | 1 |
| 2015 | 2 |
| 2017 | 1 |
| 2018 | 3 |
| 2023 | 1 |
| 2025 | 1 |
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 c.\"eventStateOrRegion\" = 'ID' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '0203'))
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 c."eventStateOrRegion" = 'ID' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '0203')) 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 WPR25LA283Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 150F · Rigby, IDThe flight instructor’s improper flap position during takeoff, which resulted in degraded climb performance and a subsequent impact with a building.NTSB WPR24LA034Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 310 · Hayden, IDThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack, which resulted in a loss of control and subsequent stall during a precautionary landing. Contributing to the accident was the improper maintenance…NTSB DCA18IA264Incident · No injuriesIncident investigationFinal reportLindstrand 105A · Driggs, IDthe drone pilot's decision to fly without pre-coordination, and without the requisite skills and knowledge, to maneuver the drone in close proximity to another aircraft.NTSB WPR18LA176Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA 18-150 · Yellow Pine, IDThe pilot’s failure to maintain adequate airspeed while conducting a go-around and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall/spin at too low of an altitude to recover. Contributing to the accident were…NTSB WPR18FA141Accident · 1 fatalField investigationFinal reportCessna 182G · Cascade, IDThe non-instrument-rated pilot's improper decision to initiate a visual flight rules flight into an area with low ceilings due to mountain obscuration, which resulted in controlled flight into terrain.NTSB GAA18CA028Accident · No injuriesData collectionFinal reportStinson 108 · Lewiston, IDThe pilot’s failure to maintain directional control during the landing roll. Contributing to the accident was the pilot’s failure to obtain appropriate training in the airplane before flying solo.NTSB WPR15LA237Accident · No injuriesLimited investigationFinal reportPiper PA 28-181 · American Falls, IDThe low flight time pilot's inadequate in-flight fuel planning, which resulted in fuel exhaustion, a loss of engine power, and an off-airport landing in rough terrain.NTSB GAA15CA153Accident · No injuriesData collectionFinal reportGrumman American Avn. AA 5A · Mackay, IDThe student pilot's disorientation in mountainous terrain and course deviation into a canyon, which resulted in the airplane's inability to out climb terrain and a forced landing.NTSB WPR12FA089Accident · 1 fatalField investigationFinal reportGarza Lancair IV-TP · Boise, IDA loss or commanded reduction of engine power during the initial climb for reasons that could not be determined because of postaccident impact damage and fire destruction to engine systems and components. Also causal were the pilot's failure to maintain…NTSB WPR11CA413Accident · Minor injuriesData collectionFinal reportCessna 172F · Atlanta, IDThe pilot’s misjudgment of his final approach path. Contributing to the accident was the pilot’s inadequate preflight planning.NTSB WPR11FA392Accident · 1 fatalField investigationFinal reportBriegleb BG-12B · Moore, IDThe pilot’s decision to perform a low pass over the runway in the opposite direction of his intended landing, and his subsequent failure to maintain airspeed and glider control during the reverse-course maneuver. Contributing to the accident was the effect of…NTSB WPR11LA324Accident · Serious injuriesLimited investigationFinal reportM Squared Sprint 1000 · Heise, IDThe pilot's failure to maintain adequate airspeed while maneuvering, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's lack of experience in the accident airplane make and model.NTSB WPR09CA259Accident · Minor injuriesData collectionFinal reportVenus Trike · Kuna, IDThe complete loss of engine power for undetermined reasons, and the overload failure of the nose landing gear strut during the roll out over soft/rough terrain.NTSB WPR09FA116Accident · 1 fatalField investigationFinal reportPiper PA-24-260 · Hagerman, IDThe student pilot's spatial disorientation, which resulted in a loss of aircraft control and subsequent in-flight breakup. Contributing to the accident was the pilot's mental condition which could have contributed to the inappropriate decision to fly the…NTSB LAX08CA081Accident · No injuriesData collectionFinal reportMaule M-8-235 · Grangeville, IDThe pilot's failure to maintain directional control during the landing roll, which resulted in a ground loop/swerve. A contributing factor was the pilot's lack of recent experience.