NTSB investigations, 2009, LA
8 cases where the sequence of events included Collision with terr/obj (non-CFIT).
Cases per year
| 2008 | 5 |
|---|---|
| 2009 | 8 |
| 2010 | 5 |
| 2011 | 11 |
| 2012 | 9 |
| 2013 | 11 |
| 2014 | 10 |
| 2015 | 8 |
| 2016 | 11 |
| 2017 | 9 |
| 2018 | 7 |
| 2019 | 9 |
| 2020 | 4 |
| 2021 | 7 |
| 2022 | 4 |
| 2023 | 6 |
| 2024 | 8 |
| 2025 | 3 |
| 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\" = '470' 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" = '470' 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 CEN09CA497Accident · Serious injuriesData collectionFinal reportunknown kit · Abbeville, LAA total loss of engine power for undetermined reasons.NTSB CEN09CA510Accident · No injuriesData collectionFinal reportWohnoutka Steven M Team Z MAX · Iowa, LAA total loss of engine thrust during initial climb due to the failure of the airplane's propeller as a result of preexisting damage.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 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 CEN09LA225Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-602 · Ville Platte, LAThe pilot's failure to maintain clearance from the power transmission lines during an aerial application run.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…