NTSB investigations, LA
180,616 investigations by the National Transportation Safety Board since 1962: 174,594 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 FTW82DA175Accident · No injuriesFinal reportPiper PA-32RT-300 · Pineville, LADuring taxi to the runway for takeoff, the right main gear dropped into an unmarked hole on the right edge of the taxiway resulting in substantial damage to the aircraft.NTSB FTW82DA233Accident · No injuriesFinal reportCessna 172P · Chandeleur Isla, LAWhile on a local photo and sight-seeing flight, the pilot elected to land on Chandeleur island. After landing, he prepared to depart, using the recommended soft field technique. During the takeoff, there was a strong crosswind which caused the aircraft to…NTSB FTW82DA169Accident · No injuriesFinal reportGrumman G164A · Welsh, LADuring the initial takeoff with a load of fertilizer the engine lost power and the load was dumped. A forced landing wasmade in a plowed, wet field and the aircraft nosed over. Investigation revealed the cylinder head failed.NTSB FTW82FRJ10Accident · 1 fatalFinal reportContinental Tomcat MK6C · Cottonport, LAThe plt was familiarizing himself with the acft & the local area. The plt's log book showed only one hour of flt time logged between 9/23/81 & the date of the accident. Witnesses observed the acft flying for some time over the city at 300-400 ft AGL making…NTSB FTW82FRD10Accident · 1 fatalFinal reportCessna 207 · Franklinton, LAThe passenger stated that after sharp turns at low altitude over a farm house they did a roll & were too low to recover prior to striking trees. The acft came to rest inverted in a 4-5 ft deep farm pond. The autopsy report shows the plt's death by asphyxia…NTSB FTW82FRJ11Accident · Serious injuriesFinal reportCessna 170B · Plain Dealing, LAThe aircraft was observed over a river at low altitude when it struck a powerline. The pilot was unable to recall anything about the flight after the takeoff. The passenger reported that they had flown to springhill to obtain 80 octane fuel, and while…NTSB FTW82DA160Accident · No injuriesFinal reportGrumman G-164A · Oberlin, LAThe pilot reported that during landing, his left brake failed. He elected to go-around. However, while maneuvering to avoid a building, the aircraft struck a rice dike and crashed. The pilot reported that the left brake thrust plate had broken during the…NTSB FTW82FA145Accident · 2 fatalField investigationFinal reportBell 212 · Intracoastal Ci, LAThe helicopter was in cruise flight when a sudden and severe right yaw occurred. Subsequently, it was autorotated to a ditching in rough water. Touchdown was made on top of a wave, then the helicopter rolled over. The survivors did not get the raft out.…NTSB FTW82DA144Accident · No injuriesFinal reportBell 206L-1 · Cameron, LAN2138Y departed Cameron, LA after refueling en route to an offshore rig. Shortly after departure, while over water, the aircraft began to yaw and vibrate severely. The pilot stated that the tail rotor pedals "kicked" hard when additional power was applied.…NTSB FTW82DA124Accident · No injuriesFinal reportCessna 152 · Lafayette, LAEn route to Lafayette, LA on a cross country the engine quit. A forced landing in a soft plowed field caused the landing gear to separate and the aircraft to nose over.NTSB FTW82FRD09Accident · 2 fatalFinal reportCessna A185E · New Orleans, LAThe pilot of the amphibious aircraft initiated a takeoff on runway 10. Witnesses stated that the engine began losing power. After taking off, the aircraft was observed to make a sharp left turn back toward the airport while still at a low altitude. Some…NTSB FTW82DA102Accident · No injuriesFinal reportCessna 152 · New Orleans, LAThe student pilot was doing touch and go landings on runway 36. The wind was 290 degrees at 10 KTS. During a landing roll the student lost control and departed the left side of the runway. The aircraft sank into the mud and nosed over.NTSB FTW82DA089Accident · No injuriesFinal reportRockwell S-2R · Oberlin, LAAs the pilot was completing a spray run, he started to close the hopper, but it felt to him that the handle had broken. He looked inside the cockpit momentarily. When he looked back outside, the aircraft had begun a descent. It was too close to the ground to…NTSB FTW82FRJ09Accident · Serious injuriesFinal reportCessna 182L · Farmerville, LAThe pilot reported that his takeoff and climb to 2200 ft MSL were normal. After the plane was in cruise configuration, he heard an abnormal noise and decided to return to the airport. The noise level increased and the engine began to vibrate. The pilot…NTSB FTW82DA080Accident · No injuriesFinal reportCessna 421B · Eunice, LAShortly after touchdown during a landing. The left main gear collapsed. The aircraft then veered off the left side of the runway and struck a ditch. The right main and nose gear collapsed after striking the ditch. An examination of the left gear revealed that…NTSB FTW82DA066Accident · No injuriesFinal reportCessna A185F · Near Patterson, LAAfter landing the pilot began to step taxi on an unfamiliar canal to a drilling rig location. While negotiating a turn in the canal, the left wing struck a tree limb. The aircraft veered to the left and the right wing dropped and hit the water.NTSB FTW82DA063Accident · No injuriesFinal reportCessna 140 · Krotz Springs, LADuring the power recovery from a simulated forced landing to a railroad right-of-way the aircraft struck four strands of telephone wire which ran perpendicular to the tracks. The aircraft was landed at a nearby airport where post-flight inspection revealed…NTSB FTW82DA059Accident · No injuriesFinal reportCessna 310D · Farmerville, LABefore this flight, the aircraft had not been flown for a period of time. The pilot was the owner of a maintenance facility and was preparing to perform an annual inspection of the aircraft. He elected to fly it around the airport to warm up the engines…NTSB FTW82FRD08Accident · 2 fatalFinal reportCessna 150G · Jeanerette, LAAccording to a friend of the deceased pilot and his female companion the three of them had been at a nightclub until 0215 CST. The friend then followed them to the airport, since he lived adjacent to the airport. After arriving he heard an aircraft takoeff.…NTSB FTW82DA048Accident · No injuriesFinal reportCessna A185F · S. Of Morgan Ci, LAThe pilot was making a westbound takeoff from a canal with a 15 knot south crosswind when his boot and pant leg became entangled in the aircraft's water rudder lever. This caused the pilot to lose control and the aircraft drifted to the right into a moored…NTSB FTW82DA042Accident · No injuriesFinal reportCessna 150H · Shreveport, LAThe pilot departed stillwater, ok at 0950 CST on a flight to mcalister, OK. While airborne, he amended his destination to Shreveport, LA with an estimated arrival time of 1251 CST. On his flight plan, he estimated 3 hours of fuel on board. At 1253 CST, the…NTSB FTW82DA045Accident · No injuriesFinal reportCessna 180K · S.E. Of Houma, LAThe pilot elected to takeoff from a canal with a quartering tailwind due to approaching fog. The aircraft drifted left and its wing struck a piling.NTSB FTW82FA041Accident · 1 fatalField investigationFinal reportBell Helicopter 206L-1 · Houma, LAThe acft was enroute to the ship shoal area in the gulf of Mexico. Another plt who departed earlier advised the plt that he & another acft had turned around & was returning after encountering a low ceiling & reduced visibility. The surviving pax stated that…NTSB FTW82FRJ07Accident · Minor injuriesFinal reportBellanca 17-30A · Homer, LADuring an IFR flight at 5000 ft MSL, the engine began running rough. The pilot attempted to restore power, but eventually, the engine began to windmill with no apparent thrust. Unable to maintain altitude, the pilot descended through a cloud layer and broke…NTSB FTW81FA032Accident · 2 fatalClosedAero Comdr 690C · Patterson, LANTSB FTW82DA023Accident · 1 fatalClosedPiper PA-28 · Garden City, LANTSB FTW82DRJ05Accident · Minor injuriesClosedPiper JC3-65 · Oil City, LANTSB FTW82DRD06Accident · No injuriesClosedBell 206L-1 · Cameron, LANTSB FTW82DRD05Accident · No injuriesClosedCessna A185F · Pecan Island, LANTSB FTW82DRD04Accident · No injuriesClosedStinson 108-3 · Thibodaux, LANTSB FTW82DRJ04Accident · Minor injuriesClosedGrumman G-164A · Elm Grove, LANTSB FTW82FA012Accident · 1 fatalClosedHiller FH1100 · Porte Barre, LANTSB FTW82FRD03Accident · No injuriesClosedPiper PA-38 · Lake Charles, LANTSB FTW82DRJ02Accident · Minor injuriesClosedCessna 182 · Farmerville, LANTSB FTW82DRD02Accident · No injuriesClosedCessna A185F · Patterson, LANTSB FTW82DA007Accident · No injuriesClosedAerospatle AS350D · Houma, LANTSB FTW82DRD01Accident · Minor injuriesClosedCessna TU206G · Lafayette, LANTSB FTW81DRD50Accident · No injuriesClosedCessna A185F · Leeville, LANTSB FTW81DRD48Accident · No injuriesClosedTom Cat 47-MK6 · Ramah, LANTSB FTW81DRD47Accident · No injuriesClosedGrum Amer AA-5A · Opelousas, LANTSB FTW81DRD49Accident · No injuriesClosedCessna 185 · Grand Isle, LANTSB FTW81DRD46Accident · Minor injuriesClosedCessna A185F · Intracstl Cy, LANTSB FTW81FRD44Accident · Serious injuriesClosedCessna A188B · Port Barre, LANTSB FTW81DRJ35Accident · No injuriesClosedBeech D18S · Simsboro, LANTSB FTW81DRD43Accident · No injuriesClosedCessna A185F · Morgan City, LANTSB FTW81FRD45Accident · No injuriesClosedPiper PA-32R · Lake Charles, LANTSB FTW81DRJ34Accident · No injuriesClosedCallair A-5 · Cottonport, LANTSB FTW81DRD40Accident · No injuriesClosedCessna 185F · Lake Arthur, LANTSB FTW81FA138Accident · 2 fatalClosedBeech C24R · Shreveport, LANTSB FTW81DRD42Accident · Minor injuriesClosedCallair A-9B · Maringouin, LA