NTSB investigations, 2011, AL
5 cases where the sequence of events included Loss of control in flight.
Cases per year
| 2008 | 8 |
|---|---|
| 2009 | 3 |
| 2010 | 3 |
| 2011 | 5 |
| 2012 | 6 |
| 2013 | 1 |
| 2014 | 5 |
| 2015 | 5 |
| 2016 | 3 |
| 2017 | 3 |
| 2018 | 1 |
| 2019 | 1 |
| 2020 | 8 |
| 2021 | 3 |
| 2022 | 4 |
| 2023 | 5 |
| 2024 | 2 |
| 2025 | 1 |
| 2026 | 2 |
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 year(c.\"eventDate\") = 2011
AND c.\"eventStateOrRegion\" = 'AL' 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") = 2011 AND c."eventStateOrRegion" = 'AL' 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 ERA12CA096Accident · Serious injuriesData collectionFinal reportThompson Tommy W Loehle P5151 · Courtland, ALThe airplane's inadvertent encounter with excessive windshear while on the downwind traffic pattern leg at low altitude, which resulted in the pilot's inability to arrest the airplane’s descent. Contributing to the accident was the pilot's decision to fly the…NTSB ERA11LA496Accident · 1 fatalLimited investigationFinal reportAero Adventure Zephyr II · Sylacauga, ALThe pilot's incapacitation due to a heart attack during takeoff, which led to an in-flight loss of airplane control.NTSB ERA11FA391Accident · 7 fatalField investigationFinal reportCessna 421C · Demopolis, ALThe pilot's failure to maintain airplane control during a single-engine approach and his failure to fly an appropriate traffic pattern for a single-engine landing. Contributing to the accident was a total loss of engine power on the right engine due to a…NTSB ERA11LA135Accident · Serious injuriesLimited investigationFinal reportBelcher William B II Firestar · West Blocton, ALThe student pilot's failure to maintain adequate airspeed while maneuvering, which resulted in an aerodynamic stall.NTSB ERA11FA107Accident · 1 fatalField investigationFinal reportBeech 58P · Birmingham, ALThe pilot's failure to maintain control of the airplane during an instrument approach due to spatial disorientation.