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 FTW02LA138Accident · No injuriesLimited investigationFinal reportEnstrom 280FX · Alsatia, LAThe main rotor contact to the tail boom resulting from the pilot leaving the helicopter unattended while the rotors were engaged.NTSB FTW02LA127Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301T · Bogalusa, LAa deer that ran in front of the airplane during the takeoff phase. A contributing factor was the lack of an airport perimeter fence to prevent deer from entering the runway environment.NTSB FTW02FA113Accident · 2 fatalField investigationFinal reportBeech D-45 · Minden, LAThe private pilot's failure to maintain aircraft control during a go-around. Contributing factors were the private pilot's impairment due to drugs, the pilot-rated passenger's lack of experience in the airplane, and the prevailing gusty crosswind conditions.NTSB FTW02LA107Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Ferriday, LAthe failure of the number three cylinder exhaust rocker arm, resulting in a total loss of engine power. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW02LA086Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-502B · Extension, LAThe pilot's failure to maintain aircraft control. A factor was the pilot's impairment due to drugs.NTSB FTW02FA062Accident · 1 fatalField investigationFinal reportBeech 95-B55 · Oak Grove, LAthe pilot's failure to maintain control of the airplane while maneuvering resulting in an inadvertent stall/spin.NTSB FTW02LA047Accident · No injuriesLimited investigationFinal reportCurtiss-Wright SB2C-5 · New Orleans, LAthe Helldiver pilot's failure to maintain visual separation with the Cessna while taxiing. Contributing factors were the Cessna pilot's failure to comply with the local controller's instructions to continue taxiing and the failure of the local and ground…NTSB FTW02FA037Accident · 1 fatalField investigationFinal reportGrumman American AA-1B · Patterson, LAThe pilot's mismanagement of fuel with the positioning of the fuel selector in the off position and his failure to maintain airspeed resulting in fuel starvation, and the airplane entering into a stall.NTSB FTW02LA034Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-802A · Benton, LAin-flight collision with trees while on final approach to land for an undetermined reason.NTSB FTW02LA033Accident · No injuriesLimited investigationFinal reportBell 407 · Erath, LAThe pilot's inadvertant application of full right pedal which resulted in the baggage compartment door to open in-flight and a tie down rope to become entangled in the tail rotor drive system, and the failure of the tail rotor drive shaft resulting in the…NTSB FTW02TA007Accident · No injuriesFinal reportCessna A185F · Houma, LAthe pilot's high flare, which resulted in a hard landing.NTSB FTW02LA010Accident · No injuriesLimited investigationFinal reportAir Tractor 402 · Angie, LAthe loss of engine power during takeoff for undetermined reasons.NTSB FTW01LA204Accident · Serious injuriesLimited investigationFinal reportCessna A188B · Harrisonburg, LAloss of control during approach for an undetermined reason.NTSB FTW01LA203Accident · 1 fatalLimited investigationFinal reportGrumman G-164B · Lydia, LAthe pilot's failure to maintain clearance with a marked tower while maneuvering.NTSB FTW01LA193Accident · No injuriesLimited investigationFinal reportGrumman G164B · Rayville, LAthe partial failure of the magneto drive coupling while maneuvering, which resulted in a loss of engine power and a forced landing. A contributing factor to the accident was the lack of suitable terrain for the forced landing.NTSB FTW01LA195Accident · Serious injuriesLimited investigationFinal reportBell 206L-3 · Cameron, LAfuel contamination due to the combination of DIEGME, water, and bacterial growth, which resulted in formation of an apple-jelly type material that blocked the fuel nozzle screen and led to a loss of engine power.NTSB FTW01LA189Accident · No injuriesLimited investigationFinal reportDonald A Chiasson FP-404 · Port Allen, LAThe loss of engine power for undetermined reason. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW01LA178Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Grand Coteau, LAthe loss of engine power while maneuvering, which resulted from a fractured #4 cylinder head at the exhaust valve rocker arm boss. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW01LA177Accident · Minor injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Bunkie, LAThe loss of engine power for undetermined reasons while maneuvering. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW01LA176Accident · No injuriesLimited investigationFinal reportSikorsky SK-76A · New Iberia, LAthe loss of control while maneuvering for undetermined reasons.NTSB FTW01LA158Accident · 1 fatalLimited investigationFinal reportPiper PA-32R-300 · Belle Chase, LAthe pilot's failure to maintain clearance with a utility pole while maneuvering. Contributing factors were the pilot's impairment due to alcohol intoxication and the night light conditions.NTSB FTW01LA152Accident · 1 fatalLimited investigationFinal reportMottier RV-6 · Hammond, LAthe pilot's failure to maintain aircraft control following a loss of engine power. A factor was the loss of engine power during takeoff initial climb for undetermined reasons.NTSB FTW01LA148Accident · No injuriesLimited investigationFinal reportCessna 152 · Lapace, LAthe student pilot flared the airplane high, which resulted in a hard landing.NTSB FTW01LA146Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Denham Springs, LAthe pilot's inadequate preflight planning and decision making, which resulted in the airplane's performance being exceeded during the takeoff initial climb. A contributing factor was the rising terrain.NTSB FTW01LA145Accident · No injuriesLimited investigationFinal reportCessna 172S · Baton Rouge, LAthe student pilot's improper recovery from a bounced landing.NTSB FTW01LA133Accident · No injuriesLimited investigationFinal reportCessna 172M · Patterson, LAthe pilot's failure to maintain control during the go-around. A contributing factor was the wind gust.NTSB FTW01LA103Accident · Serious injuriesLimited investigationFinal reportJoe Underwood Lazer Z · Bossier City, LAthe pilot's failure to maintain control during the low level maneuver. A contribiting factor was the windshear.NTSB FTW01LA093Accident · No injuriesLimited investigationFinal reportEmpson F4UCorsair · Baton Rouge, LAthe pilot's inadequate preflight planning resulting in fuel exhaustion during approach. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW01LA082Accident · Serious injuriesLimited investigationFinal reportChampion 7KCAB · Ragley, LAthe loose clamp (Nicopress fitting) on the elevator control cable due to inadequate quality control during the cable's manufacturing, which allowed the cable to disconnect and restricted the pilot's control of the airplane during landing.NTSB FTW01LA071Accident · No injuriesLimited investigationFinal reportBeech 58 · Shreveport, LAthe pilot's failure to maintain visual separation with a parked airplane while taxing. Contributory factors were the dark night light conditions, the rain, and the non-lighted ramp area where the unoccupied airplane was parked.NTSB FTW01LA070Accident · No injuriesLimited investigationFinal reportBartels Rans S-7 · Lafayette, LAthe pilot's improper flare which resulted in a hard landing.NTSB FTW01FA063Accident · 2 fatalField investigationFinal reportAero Vodochody L-39C · Pecan Island, LAthe pilot's failure to maintain altitude/clearance from terrain while performing low level aerobatics. A factor was fatigue.NTSB FTW01IA062Incident · No injuriesIncident investigationFinal reportCessna 172S · Ruston, LAthe loss of engine power while manuevering as a result of an incorrect mixture control adjustment. A contributing factor was the lack of suitable terrain for the ensuing forced landing.NTSB FTW01LA067Accident · No injuriesLimited investigationFinal reportBritish Aerospace HS.125-700A · New Orleans, LAthe pilot-in-command's inadequate preflight inspection, which resulted in a flight with a blocked fuel tank vent. A contributing factor was maintenance personnel's failure to remove the tape covering the fuel tank vent following a pressure test.NTSB FTW01LA032Accident · 1 fatalLimited investigationFinal reportSmith Team Tango 2 · Dry Creek, LAthe pilot's VFR flight into IMC while in cruise, which resulted in his loss of control of the airplane due to spatial disorientation. Contributing factors were the clouds, and icing weather conditions, and the inadequate weather briefing.NTSB FTW01LA022Accident · No injuriesLimited investigationFinal reportCessna 172K · Belcher, LAthe total loss of engine power due to carburetor ice. Contributing factors were the weather conditions conducive to carburetor icing and the lack of suitable terrain available for the forced landing.NTSB FTW01FA020Accident · 1 fatalField investigationFinal reportCessna 185F · Jena, LAThe pilot's decision to land on a highway with vehicle traffic and obstacles and his failure to maintain proper clearance from the obstacles.NTSB FTW00LA271Accident · No injuriesLimited investigationFinal reportTemco Luscombe 11A · Hammond, LAthe pilot's improper fuel consumption calculations, which resulted in fuel exhaustion. A contributory factor was the fuel cap leak, due to a worn seal.NTSB FTW00LA266Accident · No injuriesLimited investigationFinal reportCessna 150K · New Orleans, LAThe pilot's failure to maintain control of the aircraft during an aborted landing. A factor was the crosswind.NTSB FTW00LA260Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Blanchard, LAThe student pilot's failure to refuel, which resulted in fuel exhaustion. Factors were the dark night light conditions and lack of suitable terrain for the forced landing.NTSB FTW00LA239Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Kaplan, LAthe failure of the supercharger during takeoff. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW00LA233Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-502 · Deerpark, LAthe failure of both pilots to maintain a visual outlook during landing approach. A contributing factor was both pilot's failure to follow recommended traffic patterns.NTSB FTW00LA227Accident · No injuriesLimited investigationFinal reportChampion 7KCAB · Rayville, LAThe flight instructor's failure to maintain directional control. A factor was the wind gusts.NTSB FTW00LA210Accident · 1 fatalLimited investigationFinal reportGrumman-Schweizer G-164B · Ville Platte, LAThe loss of control for an undetermined reason.NTSB FTW00LA209Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Kaplan, LAThe loss of engine power for an undetermined reason. A factor was the lack of suitable terrain for the forced landing.NTSB FTW00LA199Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Chase, LAThe failure of the pilot to maintain clearance with the deer stand. Factors were the chemical covering the windshield and the glare from the setting sun.NTSB FTW00LA223Accident · No injuriesLimited investigationFinal reportEngineering & Research Ercoupe 415-CD · Abbeville, LAThe pilot's misjudged flare and improper recovery from a bounced landing. A factor was the crosswind condition.NTSB FTW00LA181Accident · Minor injuriesLimited investigationFinal reportBell 206B · Deville, LAthe pilot's failure to maintain clearance with the external load that was setting on the ground while hovering. A contributing factor was the pilot's diverted attention.NTSB FTW00LA180Accident · No injuriesLimited investigationFinal reportCessna A185F · New Orleans, LAThe pilot's failure to maintain directional control during landing roll, which resulted in a ground loop.NTSB FTW00LA178Accident · Minor injuriesLimited investigationFinal reportGulfstream-Schweizer G-164D · Welsh, LAThe excessive wear of the reduction gearbox's 1st stage sungear, which resulted in its subsequent fatigue fracture and failure. Factors were the operator not performing the recommended overhaul of the engine, and a lack of suitable terrain for the forced…