Skip to content

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.

Defining event

Finding

Phase of flight

Aircraft model

Cases, newest first

Query with SQL

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

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 FTW95LA165Accident · Minor injuriesLimited investigationFinal reportMaule MXT-7-180 · Eunice, LAThe pilot's failure to maintain clearance. A factor was the windshear condition.Apr 11, 1995 · N563AB · Substantial damage NTSB FTW95LA159Accident · Serious injuriesLimited investigationFinal reportRobinson S-12 Airaile · Sugartown, LAA partial loss of engine power for reasons undetermined. A factor was the lack of suitable terrain on which to make a forced landing.Apr 7, 1995 · N53CR · Destroyed NTSB FTW95LA136Accident · No injuriesLimited investigationFinal reportCessna 152 · New Roads, LAThe pilot's improper bounced landing recovery technique. Factors were his failure to execute a go-around, his improper landing flare, and the other pilot's premature taxiing onto the runway for takeoff.Mar 11, 1995 · N89359 · Substantial damage NTSB FTW95FA106Accident · 1 fatalField investigationFinal reportCessna 150 · Arnaudville, LAThe pilot's failure to maintain adequate airspeed while circling at low altitude, which resulted in an inadvertent stall and subsequent collision with terrain (wooded river bank). A factor relating to the accident was: the pilot's use of a drug that was not…Feb 4, 1995 · N6464T · Destroyed NTSB MIA95LA055Accident · Serious injuriesLimited investigationFinal reportMcDonnell Douglas MD-88 · Monroe, LAan in-flight encounter with weather during a climb, resulting in an injury to a flight attendant who got out of her seat to perform a duty.Jan 6, 1995 · N981DL · No damage NTSB FTW95LA056Accident · No injuriesLimited investigationFinal reportBell 206B · Natchitoches, LAThe delayed flare and the improper touchdown by the pilot in command. Factors were the operation of the aircraft with known deficiencies by the operator and the pilot, delayed maintenance, and, an engine compressor assembly stall, combined with erosion and…Nov 29, 1994 · N2183P · Destroyed NTSB FTW95FA047Accident · 1 fatalField investigationFinal reportGrumman-Schweizer G-164B · Wisner, LAThe pilot's failure to maintain minimum required airspeed for flight. A factor was the pilot's lack of total experience in the type of aircraft.Nov 16, 1994 · N48398 · Substantial damage NTSB CHI95FA035Accident · 1 fatalField investigationFinal reportSikorsky S-76A · Cameron, LAthe copilot's failure to maintain altitude and the pilot-in-command's inadequate supervision of the operation. Factors include the dark night and low ceiling, and the flightcrew's failure to set the proper altimeter setting.Nov 9, 1994 · N2620 · Destroyed NTSB FTW95LA032Accident · No injuriesLimited investigationFinal reportBell 206L-3 · Ruston, LAThe pilot's improper handling of the helicopter after an apparent loss of power during a practice autorotation.Oct 27, 1994 · N206SF · Substantial damage NTSB FTW95FA016Accident · 1 fatalField investigationFinal reportRobinson R22 Beta · Eunice, LAThe pilot's failure to properly use carburetor heat, the formation of carburetor ice, and failure of the pilot to maintain rotor RPM after loss of engine power, which resulted in a loss of control and collision with terrain. A factor related to the accident…Oct 14, 1994 · N80546 · Destroyed NTSB FTW95LA015Accident · No injuriesLimited investigationFinal reportCessna 185 · Abbeville, LAThe pilot's failure to compensate for wind conditions. A factor was the crosswind.Oct 6, 1994 · N95DM · Substantial damage NTSB FTW95LA009Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Oak Grove, LAThe pilot misjudged clearance from the vehicle.Oct 3, 1994 · N6676K · Substantial damage NTSB FTW94LA319Accident · No injuriesLimited investigationFinal reportLockheed PV-2 · Lafayette, LAThe pilot's inadvertent gear retraction.Sep 30, 1994 · N6857C · Substantial damage NTSB FTW94FA279Accident · No injuriesField investigationFinal reportDassault DA 200 · New Orleans, LAThe captain's decision to abort the takeoff after accelerating past V1. A factor was the fluctuating engine instrument for undetermined reasons.Aug 26, 1994 · XASKO · Substantial damage NTSB FTW94LA270Accident · 1 fatalLimited investigationFinal reportGrumman G-164B · Shreveport, LAThe pilot's incapacitation due to a heart attack.Aug 12, 1994 · N48664 · Destroyed NTSB FTW94FA262Accident · 1 fatalField investigationFinal reportGrumman G-164B · Henderson, LAThe pilot's failure to maintain clearance from a known object.Aug 5, 1994 · N6804Q · Destroyed NTSB FTW94LA257Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-502 · Bosco, LAThe pilot's failure to maintain clearance with the telephone pole.Aug 1, 1994 · N9152C · Destroyed NTSB FTW94LA253Accident · No injuriesLimited investigationFinal reportHughes 269A · Leander, LAInadequate maintenance and a fatigue failure of a #1 cylinder connecting rod bolt. A factor was the lack of suitable terrain available to the pilot for a forced landing.Aug 1, 1994 · N9062G · Substantial damage NTSB FTW94FA241Accident · 1 fatalField investigationFinal reportSchweizer G-164B · Foules, LAThe pilot's failure to maintain obstacle clearance.Jul 21, 1994 · N6617Q · Destroyed NTSB FTW94LA230Accident · Serious injuriesLimited investigationFinal reportNorth American Navion 4 · Dupont, LAThe loss of engine power due to inadequate maintenance adjustment of accessory drive starter gear screws which disengaged in flight. Factors were the lack of suitable terrain for the forced landing and non compliance with the applicable service letter.Jul 12, 1994 · N8648H · Substantial damage NTSB FTW94LA200Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-401 · Pioneer, LAFuel exhaustion due to the pilot's failure to refuel. A factor was a lack of suitable terrain for the forced landing.Jun 16, 1994 · N10112 · Substantial damage NTSB FTW94LA195Accident · 1 fatalLimited investigationFinal reportGrumman G-164D · Gilbert, LAThe inadvertent stall while performing aerobatic maneuvers at an inadequate altitude.Jun 14, 1994 · N164MC · Destroyed NTSB FTW94FA152Accident · 5 fatalField investigationFinal reportBell 206L-3 · Intracoastl Cty, LAThe pilot's failure to maintain aircraft control for undetermined reasons.May 10, 1994 · N5844 · Destroyed NTSB FTW94LA185Accident · No injuriesLimited investigationFinal reportCessna 195 · Ama, LAThe pilot-in-command's failure to maintain adequate airspeed above the aerodynamic stall speed.May 8, 1994 · N999V · Substantial damage NTSB FTW94LA108Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Rayville, LAThe pilot's failure to maintain adequate airspeed during the turn to final approach.Mar 22, 1994 · N2966M · Substantial damage NTSB FTW94LA109Accident · No injuriesLimited investigationFinal reportCessna 175 · Leesville, LAThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for a forced landing.Mar 20, 1994 · N6537E · Substantial damage NTSB FTW94LA095Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Olla, LAThe loss of engine power due to a blocked fuel line. A factor was the lack of suitable terrain for the forced landing.Mar 13, 1994 · N8645D · Substantial damage NTSB FTW94LA093Accident · Minor injuriesLimited investigationFinal reportBell 206BIII · Lake Charles, LAThe failure of the pilot to adequately perform a preflight. A factor was the soft terrain.Mar 10, 1994 · N57340 · Substantial damage NTSB DCA94MA033Accident · Minor injuriesClass 1 · MajorFinal reportSaab-Scania 340B · New Roads, LAThe captain's movement of the power levers below flight idle in flight, the inadequate certification requirements and consequent design of the airplane's power levers that permitted them to be moved below the flight idle position into the beta range, either…Feb 2, 1994 · N349SB · Substantial damage NTSB FTW94LA063Accident · Minor injuriesLimited investigationFinal reportPiper PA-34-200 · Vacherie, LAWas fuel exhaustion engine power loss due to the pilot's failure to refuel. A factor was the lack of suitable terrain available for the forced landing.Jan 7, 1994 · N1063U · Substantial damage NTSB FTW94LA043Accident · Minor injuriesLimited investigationFinal reportBell 412 · Cameron, LAThe copilot's continued flight into adverse weather conditions, and the captain's inadequate supervision. The haze and fog were factors.Dec 3, 1993 · N356EH · Destroyed NTSB FTW94IA035Incident · No injuriesIncident investigationFinal reportGrumman G159 · Pineville, LAAn encounter with a wet microburst, on final approach at 200 feet AGL, which exceeded the performance capability of the aircraft.Nov 16, 1993 · N806W · Minor damage NTSB FTW93LA263Accident · 1 fatalLimited investigationFinal reportWsk Pzl Mielec M-18A Dromader · Frogmore, LAThe pilot's failure to maintain clearance with the powerline. A factor was the dusk light condition.Sep 23, 1993 · N452TC · Destroyed NTSB FTW93LA254Accident · Serious injuriesLimited investigationFinal reportCessna 421B · Oak Grove, LADirectional control not maintained by the pilot for undetermined reasons. Factors were a fence and trees.Sep 6, 1993 · N747BW · Substantial damage NTSB FTW93IA250Incident · No injuriesIncident investigationFinal reportCessna A185F · Pilottown, LAThe pilot in command becoming physically incapacitated (heart attack).Sep 2, 1993 · N6279E · No damage NTSB FTW93FA245Accident · 1 fatalField investigationFinal reportAir Tractor AT-402 · La Barre, LALoss of control for undetermined reasons.Aug 25, 1993 · N1508X · Destroyed NTSB FTW93LA243Accident · Serious injuriesLimited investigationFinal reportBoeing A75N1 · Lafayette, LAThe engine failure for undetermined reasons. A factor was the lack of suitable terrain onto which a forced landing could be executed.Aug 21, 1993 · N450EC · Substantial damage NTSB FTW93LA241Accident · No injuriesLimited investigationFinal reportCessna 140 · Bastrop, LAThe pilot's failure to maintain directional control and his improper compensation for existing wind conditions. Factors were the crosswind and the pilot's lack of total experience in the type of aircraft.Aug 16, 1993 · N2673N · Substantial damage NTSB FTW93LA238Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Pioneer, LAThe failure by both pilots to maintain visual lookout. Factors were the inadequate radio communications by both pilots, and the departing pilot's failure to follow procedures and directives.Aug 12, 1993 · N8227K · 2 aircraft · Substantial damage NTSB DEN93LA091Accident · No injuriesLimited investigationFinal reportContinental Copters Tomcat MK5A · Duson, LAFailure of the transmission mast bearing, resulting in oil contamination and subsequent blockage of the internal oil ports and passages. Factors were: total loss of collective control and partial loss of cyclic control.Jul 30, 1993 · N9014T · Substantial damage NTSB DEN93LA076Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Kaplan, LAFailure of the spray rig which sprayed chemicals into the pilot's eyes temporarily blinding him.Jul 12, 1993 · N9680 · Substantial damage NTSB FTW93FA211Accident · 1 fatalField investigationFinal reportRockwell S-2R · Bastrop, LAThe pilot's failure to maintain terrain clearance.Jul 10, 1993 · N8512V · Destroyed NTSB FTW93LA208Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Baton Rouge, LAThe student pilot's failure to abort the landing in a timely manner and his failure to maintain directional control.Jul 7, 1993 · N7630C · Destroyed NTSB FTW93LA196Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Edgard, LAThe pilot's attempt to takeoff under conditions that exceeded the performance capability of the aircraft. A factor was the high density altitude.Jun 25, 1993 · N9772G · Substantial damage NTSB FTW93FA192Accident · Minor injuriesField investigationFinal reportBell 206L-3 · West Monroe, LAThe pilot's inadequate planning and preparation prior to takeoff, and his failure to maintain obstacle clearance. Factors were the fog and low ceilingJun 20, 1993 · N911MT · Substantial damage NTSB FTW93LA179Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Kaplan, LAThe pilot's failure to have the airplane properly attended during start when people were available. A factor was the inadequate tie down rope.Jun 5, 1993 · N6693Q · Substantial damage NTSB FTW93LA177Accident · No injuriesLimited investigationFinal reportWeatherly 620B · Crowley, LASevere propeller and airframe vibration for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.Jun 5, 1993 · N2002E · Substantial damage NTSB FTW93LA175Accident · No injuriesLimited investigationFinal reportGrumman G-164B · St. Martinville, LAThe pilot's and tractor driver's inadequate visual lookoutJun 2, 1993 · N48724 · Substantial damage NTSB FTW93FA163Accident · No injuriesField investigationFinal reportMBB BK 117 A-4 · Lafayette, LACyclic control rod movement was restricted due to improper installation of the lateral cyclic control rod by company maintenance personnel.May 25, 1993 · N401PH · Substantial damage NTSB FTW93LA162Accident · No injuriesLimited investigationFinal reportCessna A185F · Timbalier Isle, LAPilot's inadequate preflight planning and preparation in the selection of his takeoff route. A factor was the sand barMay 22, 1993 · N3588 · Substantial damage