NTSB investigations, LA
180,611 investigations by the National Transportation Safety Board since 1962: 174,590 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 FTW93LA160Accident · No injuriesLimited investigationFinal reportCessna 152 · Belmont, LAThe loss of engine power due to a sheared accessory drive pin. A factor was the unsuitable terrainNTSB FTW93LA154Accident · Serious injuriesLimited investigationFinal reportCessna 310D · Roseland, LAThe pilot's failure to refuel resulting in loss of engine power due to fuel exhaustion. The lack of suitable terrain for the forced landing was a factor in the accident.NTSB FTW93LA153Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Arnaudville, LAThe loss of engine power for undetermined reasons. A factor was the unsuitable terrainNTSB FTW93LA151Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Ville Platte, LAThe pilot's failure to maintain ground clearanceNTSB DEN93LA045Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Shreveport, LAThe pilot's inadequate compensation for wind conditions. The gusty crosswind was a factor.NTSB FTW93IA125Incident · No injuriesIncident investigationFinal reportBoeing 747-269BC · Alexandria, LAThe inflight delamination of the wing panel skin. Factors were the water contamination of the honeycomb panel.NTSB FTW93LA121Accident · No injuriesLimited investigationFinal reportCessna 150J · Waterproof, LAThe pilot's misjudged landing point and the excessive airspeed. A factor was the wet grass stripNTSB FTW93FA117Accident · 1 fatalField investigationFinal reportBeech C-45H · Mooringsport, LAA total loss of right engine power, and a partial loss of left engine power, for undetermined reasons.NTSB FTW93LA110Accident · No injuriesLimited investigationFinal reportLuscombe 8E · Abbeville, LAThe pilot's failure to compensate for crosswind conditions and the subsequent loss of directional control. Factors were the gusting crosswinds and the soft wet groundNTSB FTW93LA089Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Indian Village, LALanding performed short of the runway threshold. Factor was wet grassy terrainNTSB FTW93LA084Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Ruston, LAFailure at a hydraulic fitting, which resulted in a hydraulic leak, loss of hydraulic fluid, and subsequent loss of braking action during the landing roll.NTSB FTW93FA072Accident · 3 fatalField investigationFinal reportBeech V35B · Dixie Inn, LAThe pilot's failure to maintain control for undetermined reasons.NTSB FTW93FA055Accident · 2 fatalField investigationFinal reportMooney M20C · Deridder, LAThe pilot's loss of control of the airplane in IMC. A factor was his lack of recent instrument flight experience.NTSB FTW93LA046Accident · No injuriesLimited investigationFinal reportCessna 152 · New Orleans, LAHard landing due to the pilot's inadequate flare. A factor was the blocked rudder.NTSB FTW93LA042Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · New Orleans, LALoss of engine power due to fuel exhaustion. Factors were the inaccurate fuel consumption calculations and the unsuitable terrain.NTSB FTW93FA008Accident · 1 fatalField investigationFinal reportBeech 95-B55B · Chatham, LAThe inadvertent stall and spin. Factors were the power loss due to fuel starvation, the dark night, and his failure to use the boost pump for engine restart.NTSB FTW92FA223Accident · 1 fatalField investigationFinal reportPiper PA-30 · Broussard, LAPilot's decision to fly into known adverse weather and the resultant in flight break up of the airplane.NTSB FTW92LA214Accident · No injuriesLimited investigationFinal reportCessna A185F · Amelia, LAThe pilot's selection of unsuitable terrain for takeoff.NTSB FTW92DRD05Accident · Minor injuriesFinal reportGrumman G-164 · Thibodaux, LAThe pilot's failure to maintain clearance from the wires.NTSB FTW92DRD06Accident · No injuriesFinal reportCessna A188B · Mathew, LAThe pilot's failure to maintain directional control of the aircraft. A factor was the pilot's lack of experience in the type operation.NTSB FTW92LA199Accident · Minor injuriesLimited investigationFinal reportHughes 369HS · Monroe, LAThe pilot's failure to maintain adequate rotor RPM during autorotation. Factors were the tailwind and the power loss for undetermined reasons.NTSB FTW92LA185Accident · No injuriesLimited investigationFinal reportBeech D55 · Pineville, LAThe mechanical binding of the yoke after liftoff.NTSB FTW92LA183Accident · No injuriesLimited investigationFinal reportCessna 180K · Curlew Island, LAThe pilot's selection of unsuitable terrain for landing. A factor was the pilot's physical impairment.NTSB FTW92LA181Accident · No injuriesLimited investigationFinal reportCessna 120 · Reserve, LAThe loss of engine power due to the valve failure. A factor was the lack of suitable terrain for the forced landing.NTSB FTW92DRD04Accident · Minor injuriesFinal reportAir Tractor AT-502 · Mamou, LAThe pilot's failure to maintain proper clearance.NTSB FTW92DRD03Accident · No injuriesFinal reportAir Tractor AT-502 · Kaplan, LAThe pilot's failure to lower flaps to the takeoff position.NTSB FTW92LA155Accident · No injuriesLimited investigationFinal reportSikorsky S-76A · Morgan City, LAThe second pilot's failure to maintain aircraft control.NTSB FTW92DRD02Accident · No injuriesFinal reportGuzzino, P.A. Rotorway Exec · Iowa, LAThe non helicopter rated pilot's failure to maintain directional control during an attempted precautionary landing. A factor was the pilots total lack of experience in helicopters.NTSB FTW92LA144Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Mamou, LAThe engine failure for undetermined reasons. A factor was the lack of suitable terrain onto which the ensuing forced landing could be executed.NTSB FTW92LA136Accident · Serious injuriesLimited investigationFinal reportCessna 182Q · Port Sulphur, LAThe pilot planned the approach with a tailwind and did not attain the proper touchdown point. Factors were the tailwind and the delayed aborted landing.NTSB FTW92LA137Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Kinder, LAThe failure of the left brake which led to a loss of directional control. A factor was the rough terrain immediately adjacent to the runway.NTSB FTW92LA132Accident · No injuriesLimited investigationFinal reportSchweizer G-164D · Welsh, LAThe engine failure at liftoff due to the failure of multiple turbine blades and the pilot's inability to maintain directional control during the aborted takeoff.NTSB FTW92DRD01Accident · 1 fatalFinal reportAyres S2R · Hebert, LAThe pilot's failure to maintain adequate airspeed, resulting in an inadvertent stall and collision with terrain.NTSB FTW92LA116Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Welsh, LAPartial power loss due to the cracked engine cylinder. A factor was the lack of suitable terrain for the forced landing.NTSB FTW92FA112Accident · 2 fatalField investigationFinal reportBell 206L-3 · Venice, LAThe pilot's incapacitation due to food poisoning.NTSB FTW92LA090Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Roanoke, LAThe locking of the main landing gear brakes.NTSB FTW92FA077Accident · 1 fatalField investigationFinal reportBell 212 · Morgan City, LAThe inflight separation of the main rotor system as results of the main rotor static stop contacting the mast for undetermined reasons.NTSB FTW92LA052Accident · No injuriesLimited investigationFinal reportMaule M-7-235 · Cottonport, LAThe pilot's failure to compensate for wind conditions. A factor was the crosswind.NTSB FTW92LA043Accident · No injuriesLimited investigationFinal reportPiper PA-22 · New Roads, LAThe student pilot's loss of directional control and the resultant ground loop. Factors were the cfi's lack of supervision and the ditch adjacent to the runway.NTSB FTW92LA020Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Epps, LAThe loss of 1/2 of a propeller blade. Factors were powerplant vibration and resultant powerplant separation.NTSB FTW91LA167Accident · No injuriesLimited investigationFinal reportCessna 177B · Lake Charles, LAThe pilot's failure to perform a complete preflight inspection which resulted in a total loss of engine power due to fuel exhaustion as a result of inadequate fuel supply.NTSB FTW91DRD08Accident · No injuriesFinal reportCessna 152 · Ruston, LAThe cfi's exceeding the airplane's takeoff performance capability.NTSB FTW91LA145Accident · Minor injuriesLimited investigationFinal reportCessna T188C · Paulina, LAThe pilot's failure to maintain adequate visual lookout for the wires and his misjudging clearance when he attempted to fly under the wires.NTSB FTW91LA146Accident · Serious injuriesLimited investigationFinal reportCessna A188B · Patterson, LAThe pilot's failure to maintain clearance with the electical power line. Factors were the bright sun and chemical residue on the windshield.NTSB FTW91LA136Accident · Serious injuriesLimited investigationFinal reportRaven RX7 · Gonzales, LAUnfavorable winds at low altitude. A factor was the electrical power lines.NTSB FTW91DRD07Accident · No injuriesFinal reportGrumman G-164B · Donaldsonville, LAThe mechanical failure of the propeller blade pitch positioning bolt. A factor was the lack of suitable terrain available for the forced landing.NTSB FTW91LA126Accident · No injuriesLimited investigationFinal reportBell 47D-1 · Provencal, LAFuel leakage from the fuel drain valve. A factor was the inaccessibility of suitable terrain for fored landing.NTSB FTW91LA125Accident · No injuriesLimited investigationFinal reportBell 47G-2 · Slidell, LAThe pilot performing a touchdown autorotation to unsuitable terrain. Factors were the soft terrain and the inadequate supervision by the FAA inspector.NTSB FTW91DRD06Accident · No injuriesFinal reportBell 47-G2 · White Castle, LAThe pilot's improper aircraft handling, which resulted in settling with power.NTSB FTW91LA097Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · New Orleans, LAThe pilot's improper recovery from a bounced landing. A factor was: the pilot's lack of total experience in model.