NTSB investigations, 2019
8 cases where NTSB found Configuration.
Cases per year
| 2008 | 3 |
|---|---|
| 2009 | 1 |
| 2010 | 1 |
| 2011 | 4 |
| 2012 | 7 |
| 2013 | 8 |
| 2014 | 5 |
| 2015 | 7 |
| 2016 | 2 |
| 2017 | 8 |
| 2018 | 5 |
| 2019 | 8 |
| 2020 | 3 |
| 2021 | 5 |
| 2022 | 3 |
| 2023 | 5 |
| 2024 | 2 |
| 2025 | 2 |
| 2026 | 1 |
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\") = 2019
AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '01062017'))
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") = 2019 AND c."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '01062017')) 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 ERA20LA038Accident · No injuriesClass 3 · LimitedFinal reportMooney M20M · College Park, MDThe pilot’s improper flare, which resulted in a bounced landing, his improper airplane configuration during the attempted go-around, which resulted in the airplane not climbing, and his subsequent landing off the side of the runway.NTSB GAA19CA563Accident · No injuriesData collectionFinal reportDe Havilland Beaver DHC 2 · Mountain Village, AKThe pilot's improper takeoff configuration due to distraction, which resulted in the airplane’s failure to become airborne and its subsequent collision with rising terrain. Contributing to the accident was the pilot's failure to use the Before Takeoff…NTSB WPR19LA221Accident · Minor injuriesClass 3 · LimitedFinal reportAutoGyro Cavalon · Shelton, WAThe pilot’s failure to initiate the takeoff roll with inadequate rotor speed, and his failure to follow the published takeoff procedures, which resulted in a loss of control and impact with the ground.NTSB GAA19CA504Accident · No injuriesData collectionFinal reportCessna 182 · Oakland, CAThe pilot's premature full retraction of the flaps during a go-around and his subsequent improper decision to turn with a minimal climb gradient, which resulted in an off-airport landing and a landing gear collapse.NTSB GAA19CA332Accident · Minor injuriesData collectionFinal reportBeech 35 · Rose Hill, KSThe pilot's improper trim configuration during the takeoff roll, which resulted in the airplane becoming prematurely airborne, and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall.NTSB GAA19CA108Accident · No injuriesData collectionFinal reportDe Havilland DHC 2 · Hollister, CAThe pilot's failure to retract the amphibious float's landing gear wheels before landing on the water. Contributing to the accident was the pilot's failure to use the after takeoff and before landing checklists.NTSB GAA19CA247Accident · No injuriesData collectionFinal reportCessna 172 · Auburn, CAThe pilot's improper retraction of the flaps during a go-around and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall.NTSB ERA19FA124Accident · 1 fatalField investigationFinal reportPiper PA31 · Madeira, OHFuel starvation to the left engine and the resulting loss of engine power to that engine, and a loss of airplane control due to the pilot's failure to maintain the minimum controllable airspeed.