NTSB investigations, 2009, IN
4 cases where the sequence of events included Aerodynamic stall/spin.
Cases per year
| 2008 | 1 |
|---|---|
| 2009 | 4 |
| 2010 | 1 |
| 2011 | 2 |
| 2012 | 2 |
| 2013 | 3 |
| 2016 | 3 |
| 2017 | 1 |
| 2018 | 2 |
| 2019 | 6 |
| 2020 | 1 |
| 2021 | 2 |
| 2022 | 2 |
| 2023 | 1 |
| 2024 | 2 |
| 2025 | 2 |
| 2026 | 2 |
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\") = 2009
AND c.\"eventStateOrRegion\" = 'IN' 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\" = '241' 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") = 2009 AND c."eventStateOrRegion" = 'IN' 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" = '241' 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 CEN09CA435Accident · No injuriesData collectionFinal reportFlight Design Ctsw · North Vernon, INThe pilot's improper landing flare which resulted in a stall and nose over during touchdown.NTSB CEN09LA276Accident · Serious injuriesLimited investigationFinal reportHawkins August E Aventura II · Griffith, INThe pilot's failure to maintain control of the airplane due to an inadvertent stall. Contributing to the accident was the failure of the airspeed indicator due to separation of the pitot-static line at the left wing root.NTSB CEN09LA196Accident · 1 fatalLimited investigationFinal reportFritz RV3-A · Greencastle, INA partial loss of engine power for undetermined reasons and the pilot's failure to maintain aircraft control during the emergency descent.NTSB CEN09CA131Accident · No injuriesData collectionFinal reportCessna 150M · Sellersburg, INThe student pilot's failure to maintain adequate airspeed during takeoff, which resulted in an aerodynamic stall at a low altitude. An additional cause was the flight instructor's delayed remedial action.