NTSB investigations, LA
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.
Cases, newest first
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' 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' 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 DFW06CA048Accident · Minor injuriesData collectionFinal reportBell 206L-4 · Washington, LAThe in-flight collision with a bird and the pilot's physical impairment (vision), directional control was not possible.NTSB DFW06CA020Accident · Minor injuriesData collectionFinal reportDeussen Alexander II Rotorway Exec · Gibson, LAThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW06CA016Accident · No injuriesData collectionFinal reportCessna 210L · Baker, LAThe pilot's failure to maintain clearance during takeoff roll.NTSB DFW06CA015Accident · Minor injuriesData collectionFinal reportChamberlain Vans RV6 · Eunice, LAThe loss of engine power for undetermined reason. A contributing factor was lack of suitable terrain for the forced landing.NTSB DFW05CA236Accident · Serious injuriesData collectionFinal reportGrumman G-164B · Epps, LAThe pilot's failure to maintain clearance with the power lines.NTSB DFW05LA239Accident · Minor injuriesLimited investigationFinal reportBell 206B · New Orleans, LAThe pilot's failure to maintain directional control after encountering a loss of tail rotor effectiveness. A contributing factor was the lack of suitable terrain.NTSB DFW05LA252Accident · Minor injuriesLimited investigationFinal reportBell 206B · Myrtle Grove, LAThe pilot's loss of control in flight for undetermined reasons.NTSB DFW05CA212Accident · No injuriesData collectionFinal reportGrumman G164B · Alexandria, LAThe pilot's failure to maintain adequate airspeed which resulted in a stall. A contributing factor was the high density altitude.NTSB DFW05CA216Accident · No injuriesData collectionFinal reportCessna A188B · Winnsboro, LAThe pilot's failure to maintain directional control during the take-off roll.NTSB DFW05CA196Accident · No injuriesData collectionFinal reportCessna 120 · New Roads, LAThe pilot's failure to maintain control during the landing roll.NTSB DFW05CA191Accident · No injuriesData collectionFinal reportAir Tractor AT-502B · Gassoway, LAThe pilot's premature lift-off which resulted in an inadequate climb for terrain clearance. Also causal was the pilot's failure to abort the takeoff. A contributing factor was the high density altitude.NTSB DFW05CA186Accident · Minor injuriesData collectionFinal reportGrumman-Schweizer G-164A · Tallulah, LAThe partial loss of engine power as result of the fracture of the number five-cylinder exhaust valve rocker arm mounting boss. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW05LA183Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Pollock, LAThe loss of engine power due to a loose engine lubrication system component in the crankcase. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW05LA182Accident · No injuriesLimited investigationFinal reportAyres S2R-T34 · Bonita, LAThe failure of the pilot to maintain adequate visual lookout, which resulted in a midair collision.NTSB DFW05FA170Accident · 5 fatalField investigationFinal reportBeech E90 · New Roads, LAThe pilot's failure to maintain airspeed and subsequent loss of control during a go-around maneuver.NTSB DFW05CA169Accident · No injuriesData collectionFinal reportRobinson R44 · Rayville, LAThe pilot's loss of control following an encounter with loss of tail rotor effectiveness. A contributing factor was the high density altitude.NTSB DFW05CA149Accident · No injuriesData collectionFinal reportBell 206L-1 · Moulton Cove, LAThe loss of engine power due to foreign object ingestion into the compressor. A contributing factor was the lack of suitable terrain (swampy) for the forced landing.NTSB DFW05LA147Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Lake Charles, LAThe failure of the propeller governor which resulted in a forced landing. A contributing factor was the transmission wire.NTSB DFW05FA145Accident · 2 fatalField investigationFinal reportBeech 95-B55 · Jeanerette, LAThe pilot's failure to obtain/maintain sufficient airspeed to maintain control. A contributing factor was the loss of engine power for undetermined reason.NTSB DFW05CA135Accident · No injuriesData collectionFinal reportCessna 210L · Harvey, LAThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW05LA134Accident · No injuriesLimited investigationFinal reportGulfstream-Schweizer G-164D · Jennings, LAThe failure of both pilots to maintain adequate visual lookout, which resulted in a midair collision while on final approach.NTSB DFW05LA129Accident · 1 fatalLimited investigationFinal reportMiller Rand Robinson KR-2 · Galliano, LAThe pilot's failure to maintain airspeed which resulted in an inadvertent stall/spin during initial takeoff climb. A contributing factor was the pilot's lack of experience for the make/model airplane.NTSB DFW05LA125Accident · 2 fatalLimited investigationFinal reportAerostar International S53A · Shreveport, LAThe pilot's failure to maintain clearance from electrical power lines.NTSB DFW05LA116Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Fenton, LAThe loss of engine power due to fuel starvation as a result of blockage of the firewall fuel filter with an unknown contaminant. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW05LA102Accident · 2 fatalLimited investigationFinal reportSpearman Raptor · Bogalusa, LAThe pilot's failure to maintain control of the airplane. A contributing factor was the pilot's lack of experience in the make/model airplane.NTSB DFW05CA088Accident · Serious injuriesData collectionFinal reportBell B-206L-1 · Galliano, LAThe pilot's abrupt input of the collective while the main rotor RPM was at idle, which resulted in a separation of the tail boom.NTSB DFW05CA084Accident · No injuriesData collectionFinal reportGrumman G-164A · Gilbert, LAThe pilot's failure to maintain control of the airplane during landing. A contributing factor was a deflated right main tire.NTSB DFW05LA080Accident · Minor injuriesLimited investigationFinal reportAero Vodochody Aero. Works L-39C · Shreveport, LAThe pilot's misjudgment of airspeed and his failure to abort the landing resulting in an overrun. A contributing factor was the wet runway.NTSB DFW05LA074Accident · No injuriesLimited investigationFinal reportBell 206L-3 · Cameron, LAFuel starvation due to a blocked and collapsed fuel nozzle screen, resulting from a contaminated fuel source/facility. Factors were the inadequate maintenance/inspection of fuel sources, and the lack of suitable terrain (high sea state) for the forced landing…NTSB DFW05FA065Accident · 1 fatalField investigationFinal reportErcoupe 415-C · Alexandria, LAThe pilot's loss of control while maneuvering to land.NTSB DFW05FA055Accident · 1 fatalField investigationFinal reportBeech 95-B55 · Patterson, LAThe pilot's failure to follow check-list procedures and the required placard instructions, which resulted in the fuel selectors being selected to the improper fuel tanks for take-off, resulting in a loss of engine power to the left engine. Also causal was the…NTSB SEA05FA034Accident · 2 fatalField investigationFinal reportCessna 182R · Monroe, LAThe failure of the pilot manipulating the controls to maintain aircraft control during a night missed approach in instrument meteorological conditions. Factors include a dark night and low ceilings.NTSB DFW05IA048Incident · No injuriesIncident investigationFinal reportBeech A36 · Natchitoches, LAThe loss of engine power due to pre-ignition and detonation. Contributing factors were the lack of suitable terrain available for the forced landing and the unapproved installation of a turbocharger.NTSB DFW05FA038Accident · 2 fatalField investigationFinal reportCessna T210N · Abita Springs, LAThe loss of engine power for undetermined reasons. Also causal was the pilot's improper in-flight emergency planning when he misjudged his available altitude and made a 360 degree turn away from the airport instead of proceeding directly to it, which resulted…NTSB DFW05FA032Accident · Serious injuriesField investigationFinal reportHughes 369D · Zachary, LAThe loss of engine power as a result of fatigue cracking of the compressor adaptor coupling initiated by fretting on the pilot diameter and subsequent disconnection of the compressor from the turbine assembly. A contributing factor was the low operating…NTSB DFW05CA044Accident · No injuriesData collectionFinal reportBell B206L-1 · Patterson, LAThe loss of engine power due to fuel starvation resulting from the pilot's failure to activate the fuel boost pumps prior to takeoff. A contributing factor was that the helicopter was at an airspeed and altiutude combination (below height/velocity curve)…NTSB DFW05FA028Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Hammond, LAA loss of engine power due to the pilot's in-flight mismanagement of the available fuel supply by his failure to switch fuel tank position, which resulted in fuel starvation. Factors were the low ceilings and the prevailing dark night conditions.NTSB DFW05CA008Accident · No injuriesData collectionFinal reportPiper PA-22 · Reserve, LAThe pilot's failure to compensate for the existing wind conditions. A contributing factor was the strong crosswind.NTSB FTW04CA246Accident · No injuriesData collectionFinal reportGrumman G-164A · Gilbert, LAThe failure of a piston connecting rod for undetermined reasons resulting in the loss of engine power. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW04LA229Accident · No injuriesLimited investigationFinal reportCessna 175 · De Ridder, LAThe partial loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW04LA221Accident · Serious injuriesLimited investigationFinal reportBeech C23 · Shreveport, LAThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW04LA211Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Abita Springs, LAThe pilot's failure to maintain obstacle clearance. The pilot's inadequate evaluation of the weather and dark night conditions are contributing factors.NTSB FTW04CA193Accident · Serious injuriesData collectionFinal reportHead Balloons AX8-88 · Baton Rouge, LAThe pilot's selection of an unsuitable area for landing. A contributing factor was the high vegetation.NTSB FTW04LA201Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-400 · Clayton, LAThe pilot's failure to maintain clearance from the high tension power lines.NTSB FTW04LA196Accident · Minor injuriesLimited investigationFinal reportEverett Vidrine Dragonfly · Covington, LAthe pilot's inadequate preflight planning which failed to assure adequate takeoff performance for the airplane to clear obstacles. A contributing factor was the pilot's failure to abort the takeoff.NTSB FTW04FA186Accident · 1 fatalField investigationFinal reportBell 206 L-1 · Cameron, LAThe helicopter's in-flight collision with water for undetermined reasons.NTSB FTW04LA179Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Winnsboro, LAThe pilot's mismanagement of fuel resulting in fuel starvation. A contributing factor was the ditch.NTSB FTW04LA176Accident · Minor injuriesLimited investigationFinal reportRockwell S-2R · Jonesville, LAThe pilot's failure to maintain clearance with the power lines.NTSB FTW04FA168Accident · 3 fatalField investigationFinal reportBell 206-L1 · Vermillion Bay, LAThe pilot's continued flight into adverse weather conditions resulting in a loss of control. Contributing factors were the prevailing thunderstorms and the pilot's inadequate in flight preparation and planning.NTSB FTW04LA166Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-502B · Crowley, LAThe loss of engine power due to fuel exhaustion. A contributing factor was the lack of suitable terrain for the forced landing.