NTSB investigations, 2009, LA
7 cases where the sequence of events included Loss of control in flight.
Cases per year
| 2008 | 4 |
|---|---|
| 2009 | 7 |
| 2010 | 3 |
| 2011 | 6 |
| 2012 | 7 |
| 2013 | 11 |
| 2014 | 2 |
| 2015 | 5 |
| 2016 | 4 |
| 2017 | 1 |
| 2019 | 5 |
| 2020 | 6 |
| 2021 | 7 |
| 2022 | 5 |
| 2023 | 3 |
| 2024 | 3 |
| 2025 | 6 |
| 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\") = 2009
AND c.\"eventStateOrRegion\" = 'LA' 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") = 2009 AND c."eventStateOrRegion" = 'LA' 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 CEN10FA011Accident · 2 fatalField investigationFinal reportCessna 150F · Alexandria, LAFailure of the wingman to maintain proper separation from the lead airplane during formation maneuvers. Contributing to the accident was lead's abrupt right bank and both pilots' lack of formation training.NTSB CEN09LA571Accident · Minor injuriesLimited investigationFinal reportMesserschmitt-Boelkow-Blohm BO-105S · Thibodaux, LAThe pilot's inability to maintain control due to the mechanic's inadvertent switching of two cyclic control tubes of different lengths during maintenance.NTSB CEN09LA299Accident · Serious injuriesLimited investigationFinal reportNorthwing Apache Sport · Franklinton, LAThe pilot's failure to maintain airspeed which resulted in a stall. Contributing to the accident was the pilot's lack of flight experience in the weight-shift trike.NTSB CEN09CA272Accident · Minor injuriesData collectionFinal reportCessna A185F · Patterson, LAThe pilot's failure to maintain adequate airspeed in a turn while attempting to return to land, which resulted in an aerodynamic stall. Contributing to the accident was the reported loss of engine power for undetermined reasons.NTSB CEN09LA255Accident · 1 fatalLimited investigationFinal reportWhitehead Titan · Slaughter, LAThe pilot's incorrect use of pitch control, resulting in induced pitch oscillations and loss of aircraft control. Contributing to the accident were the pilot's total lack of experience in aircraft make/model, and his lack of recency of experience.NTSB CEN09FA178Accident · 3 fatalField investigationFinal reportCessna 182M · Albany, LAThe pilot's loss of control of the airplane due to spatial disorientation after an encounter with marginal VMC and/or instrument meteorological conditions. Contributing to the accident was the pilot’s decision to attempt the flight with the preflight…NTSB CEN09MA117Accident · 8 fatalMajor investigationFinal reportSikorsky S-76C · Morgan City, LA(1) the sudden loss of power to both engines that resulted from impact with a bird (red-tailed hawk), which fractured the windshield and interfered with engine fuel controls, and (2) the subsequent disorientation of the flight crewmembers, which left them…