NTSB investigations, LA
22 cases where NTSB found Monitoring environment.
Cases per year
| 2008 | 1 |
|---|---|
| 2009 | 2 |
| 2012 | 2 |
| 2013 | 2 |
| 2014 | 1 |
| 2015 | 1 |
| 2017 | 1 |
| 2018 | 2 |
| 2019 | 3 |
| 2021 | 2 |
| 2022 | 1 |
| 2023 | 2 |
| 2024 | 1 |
| 2025 | 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 c.\"eventStateOrRegion\" = 'LA' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '02021545'))
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 c."eventStateOrRegion" = 'LA' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '02021545')) 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 CEN25FA281Accident · 1 fatalClass 3 · FieldFinal reportBell Helicopter Textron 206L-1 · Thibodaux, LAThe pilot’s failure to maintain clearance to powerlines during an agricultural application pass.NTSB CEN25LA037Accident · No injuriesClass 4 · LimitedFinal reportBeech A36 · Pineville, LAThe airplane’s collision with a stake on a closed runway. Contributing to the accident was the pilot’s inadequate preflight planning and failure to see the closed runway markings.NTSB CEN24LA029Accident · No injuriesClass 4 · LimitedFinal reportAg-Cat G-164B · Abbeville, LAThe pilot’s failure to maintain clearance from a power line during an aerial application flight.NTSB CEN24FA021Accident · 1 fatalClass 3 · FieldFinal reportAir Tractor AT-502B · Vidalia, LAThe pilot’s failure to maintain clearance from power lines during an aerial application flight. Contributing to the accident was the pilot’s cell phone use and the position of the sun, which reduced the pilot’s ability to perceive the location of the power…NTSB CEN22LA359Accident · Minor injuriesClass 4 · LimitedFinal reportAir Tractor AT-502B · Melville, LAThe pilot improperly monitored the operating environment which resulted in a collision with a tree located in the middle of a field.NTSB CEN21LA456Accident · No injuriesClass 4 · LimitedFinal reportBell 407 · Patterson, LAThe pilot’s failure to maintain adequate clearance from a parked helicopter while hovering to reposition for takeoff.NTSB CEN21LA113Accident · 1 fatalClass 3 · LimitedFinal reportAir Tractor AT-802A · Newellton, LAThe pilot’s failure to maintain clearance from powerlines/poles and terrain while maneuvering for reasons that could not be determined based on available evidence.NTSB GAA19CA452Accident · Minor injuriesData collectionFinal reportAir Tractor AT 502 · Welsh, LAThe pilot's failure to maintain clearance from a telephone pole during an agricultural application flight.NTSB CEN19TA196Accident · No injuriesFinal reportAeronca 65 C · Gilliam, LAThe pilot's failure to see and avoid a dark-colored utility pole while taxiing for takeoff.NTSB GAA19CA115Accident · No injuriesData collectionFinal reportNavion Navion · Patterson, LAThe pilot's failure to maintain clearance from power lines while making an evasive maneuver to avoid birds.NTSB CEN18FA182Accident · 1 fatalField investigationFinal reportMD Helicopter 369D · Luling, LAThe pilot's failure to maintain clearance from the powerline structure while hovering, which resulted in an inadvertent collision with the structure and an uncontrolled descent into terrain.NTSB GAA18CA244Accident · No injuriesData collectionFinal reportLuscombe 8 · Eunice, LAThe pilot’s failure to maintain clearance from a tree while on approach to land.NTSB CEN18LA026Accident · 2 fatalLimited investigationFinal reportHughes 369D · Sulphur, LAThe pilot's failure to maintain adequate separation between a long line being used to hoist linemen from a shield wire during an external load flight, which resulted in the long line being severed.NTSB CEN15LA222Accident · 1 fatalLimited investigationFinal reportAir Tractor AT 502B · Basile, LAThe pilot’ failure to maintain adequate clearance from trees while maneuvering during an aerial application flight.NTSB CEN14LA379Accident · 1 fatalLimited investigationFinal reportKolb Mark III · Jonesville, LAThe noncertificated pilot's failure to maintain clearance from trees.NTSB CEN13LA394Accident · Minor injuriesLimited investigationFinal reportGulfstream-Schweizer A/C Gulfstream AM G-164B · Colfax, LAThe pilot’s failure to maintain clearance from a tree.NTSB CEN13LA163Accident · 1 fatalLimited investigationFinal reportPZL Mielec M-18A · Jennings, LAThe pilot’s inadequate visual lookout, which resulted in a collision with guy wires during an aerial application flight.NTSB CEN13FA009Accident · 1 fatalField investigationFinal reportBell 206B · Crowley, LAThe pilot’s failure to maintain clearance from the broadcast tower guy-wires.NTSB CEN12CA544Accident · Serious injuriesData collectionFinal reportSchweizer, N36289 G-164B · Kaplan, LAThe pilot's failure to maintain clearance from power lines during the aerial application flight.NTSB CEN09LA297Accident · Serious injuriesLimited investigationFinal reportAyres S-2R · Monroe, LAThe pilot's failure to maintain clearance from the power transmission lines during an aerial application run.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 CEN09LA039Accident · Minor injuriesLimited investigationFinal reportChamberlin Victor Wayne Minimax · Winnsboro, LAThe pilot’s failure to maintain clearance from static wires while maneuvering to avoid another airplane.