NTSB investigations, 2012, NY
4 cases where the sequence of events included Aerodynamic stall/spin.
Cases per year
| 2008 | 3 |
|---|---|
| 2009 | 5 |
| 2010 | 1 |
| 2011 | 3 |
| 2012 | 4 |
| 2013 | 3 |
| 2014 | 4 |
| 2015 | 4 |
| 2016 | 1 |
| 2017 | 4 |
| 2018 | 3 |
| 2019 | 1 |
| 2021 | 4 |
| 2022 | 2 |
| 2023 | 1 |
| 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\") = 2012
AND c.\"eventStateOrRegion\" = 'NY' 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") = 2012 AND c."eventStateOrRegion" = 'NY' 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 ERA13FA032Accident · 2 fatalField investigationFinal reportSwift Museum Foundation GC-1A · East Moriches, NYThe failure of the pilot to maintain airspeed, while attempting a precautionary landing for reasons that could not be determined from the available evidence. Contributing to the accident was the pilot’s pitch-up reaction to birds that took flight during his…NTSB ERA12LA528Accident · 1 fatalLimited investigationFinal reportSchleicher ASW-19 · Dansville, NYThe pilot’s failure to maintain glider control while maneuvering. Contributing to the accident was the pilot’s impairment due to an over-the-counter sedating antihistamine.NTSB ERA12CA341Accident · Minor injuriesData collectionFinal reportCzech Sport Aircraft A S Sportcruiser · Shirley, NYThe pilot's failure to maintain airplane control after the cockpit canopy opened during the takeoff climb. Contributing to the accident was the pilot’s failure to securely lock the canopy before takeoff.NTSB ERA12LA233Accident · Serious injuriesLimited investigationFinal reportBoehlke Kevin P 2/3 Scale Jenny · Hannacroix, NYThe non-certificated pilot's improper high-speed taxi test, which resulted in a loss of control and the pilot's subsequent decision to take off to avoid trees. Also causal, was an in-flight magneto failure, which resulted in a partial loss of engine power.…