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 FTW88DRD19Accident · No injuriesFinal reportSchweizer G-164B · Catahoula, LAThe ag airplane was being utilized to scare birds away from the rice fields. It was 15 feet AGL when the engine backfired and quit. The airplane collided with the terrain and burned. The engine and engine accessories were so destroyed by fire that nothing…NTSB FTW88DRD18Accident · Serious injuriesFinal reportGrumman G-164A · Rayne, LAAt the end of a swath run, the ag pilot pulled the airplane up and to the left to start a turn-around. The upper left wing struck a steel guy-cable of a 300 foot tower. The airplane made several turns of an inverted flat-spin before water impact into an eight…NTSB FTW88DRD17Accident · No injuriesFinal reportSchweizer G-164A · Mangham, LAThe ag airplane was spraying cotton when the engine started to vibrate. Pilot pulled airplane up and vibration was so bad power had to be reduced. Pilot made a forced landing in a muddy field. The left wing caught in tall grass and airplane cartwheeled. Pilot…NTSB FTW88IA145Incident · No injuriesIncident investigationFinal reportBell 222UT · Cameron, LAPlt stated that the acft pitched 20 deg nose down without warning while in cruise flt at 1,200' and 120 KTS. Following recovery, the acft required additional rt pedal to stay in trim and it flew about 10 deg nosed down in lvl flt. Flt diverted to the opr's…NTSB FTW88DRD16Accident · No injuriesFinal reportPZL-Mielec M18 · Bastrop, LAThis ag airplane has a hydraulic system that operates the brakes and flaps. The engine driven hydraulic pump provides pressure to the primary system for normal use and also provides pressure to an accumulator for emergency use. The pressure in the accumulator…NTSB FTW88FA136Accident · 3 fatalField investigationFinal reportDouglas DC-6A · Golden Meadow, LAAfter abt 4.3 hrs on an overwater flt, the crew rprtd they had 15 min of fuel remaining. Subsequently, 3 of 4 engs lost pwr fm fuel exhaustion. Drg an emerg lndg, the acft hit a levee & was extensively dmgd. Most of the wreckage came to rest in a dainage…NTSB FTW88LA133Accident · No injuriesLimited investigationFinal reportCessna 310B · Ruston, LABoth airplanes were in the traffic pattern. The Cessna 152 made radio calls in the blind; the Cessna 310 did not. Both airplanes were on final at the same time with the 152 in the lead and the 310 lower. The 310 passed the 152 just before touchdown. The 310…NTSB FTW88DRD14Accident · Serious injuriesFinal reportGrumman G-164A · Crowley, LAThe agricultural pilot was working in a field which had telephone lines at one end and power lines at the other. On his last run, as he started his pull up, the airplane struck the power lines at one end of the field. The airplane went through the power…NTSB FTW88DRD13Accident · Serious injuriesFinal reportGrumman G-164A · Kinder, LAThe pilot was spraying a fungicide on the field and the owner of the field was flagging for him, on the top of a dike, on the west end of the field. During normal operation, the flagman stayed in position until the airplane was 300 feet away, at which time he…NTSB FTW88LA130Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Slidell, LAThe student pilot landed on the private strip to pick up a passenger. The pilot reported that after takeoff he smelled smoke and almost immediately, the engine started cutting out. The airplane impacted the tops of tall trees, thena fence, and then impacted…NTSB FTW88DRD15Accident · No injuriesFinal reportCessna A188B · Patterson, LAShortly after takeoff, the engine lost power & the plt dumped his load. Subsequently, the acft crash landed in a cane field. No preimpact mechanical problems could be found with the engine or fuel system. Water was found in the fuel tank outlet screen,…NTSB FTW88DRD12Accident · No injuriesFinal reportTexas Helicopter M74C · Rayville, LAThe commercial pilot was spraying his cotton field with his own helicopter. The acft hit a tree during a right turning pull-up. The tail rotor blades were severed first then, during an uncontrolled right turn, the tailboom hit another tree. The main rotor…NTSB FTW88LA127Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300 · Lake Charles, LABetween flights, the pilot noticed the nose was very high while taxiing but thought it was because the strut had failed to compress. On the next touchdown, on the main wheels, the airplane started porpoising and despite the pilot's corrections, the porpoising…NTSB FTW88DRD11Accident · Minor injuriesFinal reportSchweizer G-164B · Cheneyville, LAThe ag airplane was returning after spraying chemical when the engine started to lose power. During the forced landing on a highway the left wing struck a road sign. No mechanical reason for the engine power loss was found. The acft had an annual inspection…NTSB FTW88DRD10Accident · No injuriesFinal reportBell 206L-1 · Houma, LAShortly after liftoff, the helicopter experienced a power loss at 300 feet. During the emergency landing in a wet swampy area with very high vegetation, the helicopter landed hard, and the main rotor blades struck the tailboom. At a post accident inspection,…NTSB FTW88DRD09Accident · No injuriesFinal reportGrumman G-164A · Basile, LADuring or after lift-off, the right landing gear axle assembly separated from the landing gear leg when the mounting bolts sheared. During landing, the airplane ground-looped and then flipped to the inverted position.NTSB FTW88LA116Accident · No injuriesLimited investigationFinal reportCessna 182L · Angola, LAThe pilot stated the airplane was on the takeoff roll when the seat slid to the rear. He was unable to control the airplane and it ran off the side of the runway and struck a fence. The seat track holes were worn enough that the locking pins would not stay in…NTSB FTW88DRD07Accident · Minor injuriesFinal reportPezetel M-18 · Mer Rouge, LAThe ag airplane departed the strip with 3000 lbs of fertilizer. 200 yds later it settled in a rice field and flipped forward to the inverted. No mechanical problems were found. Elevation at takeoff was 150 ft MSL. Density altitude was 2272 ft. max allowable…NTSB FTW88DRD08Accident · Minor injuriesFinal reportCessna T-210N · Ruston, LADuring climbout, the engine lost power and the airplane made a forced landing in a wooded area. After hitting trees and the terrain, the airplane burned. No pre-impact problems were found with the powerplant. Vented fuel caps had been installed but were…NTSB FTW88LA111Accident · No injuriesLimited investigationFinal reportCessna 210D · New Roads, LAThe airplane had not had an annual inspection and had not been flown for over a year. The pilot stated he found no contamination during the draining of the fuel sumps. Shortly after takeoff, the engine started sputtering and eventually stopped. During the…NTSB FTW88DRD06Accident · No injuriesFinal reportGrumman G-164A · Abbeville, LAThe ag plt had finished spreading his load of chemicals & was landing when the left brake failed to operate. He started to apply pwr for a go-around, but the eng coughed & did not respond properly. The plt then closed the throttle & appliedrgt brake to avoid…NTSB FTW88DRD05Accident · No injuriesFinal reportGrumman G-164B · Bastrop, LAThe plt said he was spreading rice when he noticed the oil pressure was decreasing & the prop was beginning to feather. With no other place to go, he landed in a plowed field. Shortly after touchdown, the acft nosed over to an inverted position. An exam…NTSB FTW88IA109Incident · No injuriesIncident investigationFinal reportBoeing 737-3T0 · New Orleans, LAA double engine flameout due to water ingestion which occurred as a result of an inflight encounter with an area of very heavy rain and hail. A contributing cause of the incident was the inadequate design of the engines and the FAA water ingestion…NTSB FTW88DRD04Accident · Minor injuriesFinal reportGrumman G-164A · Rayne, LAThe pilot had made seven previous takeoffs in that airplane, that day, on the same airstrip. On this one, the OAT was 93 degrees f. the elevation was 10 feet MSL and the density altitude was 2300 feet. The airplane was 388 pounds overweight and the CG was .5…NTSB FTW88DRD03Accident · 1 fatalFinal reportCessna 188 · Winnsboro, LAThe private pilot was practicing aerial application maneuvers with between 20 to 40 gallons of water in the spray tanks. A witness indicated that 'as the airplane started down for the pass it clearly went into a flat spin in which it made almost 2 full…NTSB FTW88DRD02Accident · No injuriesFinal reportGrumman G-164A · Jennings, LAThe ag airplane was spraying over a rice field and was making a turn-around when the airplane settled into small trees and bushes. No problems were found with the airplane or powerplant.NTSB FTW88LA093Accident · No injuriesLimited investigationFinal reportPezetel PZL-M-18 · Cheneyville, LAThe pilot said that after takeoff the aircrft seemed extremely tail-heavy and that he used 'both feet and one arm' to hold forward stick. He said the aircraft was almost uncontrollable in pitch and displayed a right turning tendendcy. The pilot returned to…NTSB FTW88FA063Accident · 2 fatalField investigationFinal reportBeech S35 · Lake Charles, LAAcft crashed into a lake shortly after being vectored onto the final approach course for an ILS at 1,500'. Two current IFR plts were on board. Wx at the time was 500' ovc with 10 miles vis and no convective activity or turbulence reported in the area. No…NTSB FTW88FA064Accident · No injuriesField investigationFinal reportPiper PA-32-260 · Laplace, LAPlt was in level crz flt at night when he observed sparks and flame coming from the eng cowling. Shortly thereafter, the eng began running rough and then seized. After declaring an emergency and being cleared straight in to a runway about 28 miles away, the…NTSB FTW88MA047Accident · 2 fatalMajor investigationFinal reportGates Learjet 36A · Monroe, LAThe crew was executing the ILS approach and had turned back inbound on the procedure turn to the outer marker when the co-pilot stated they were 5.9 DME in a calm voice with no indication of a problem. Impact with the ground occurred at about 5.9 DME,…NTSB FTW88LA043Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Woodworth, LAThe plt stated that during landing roll the aircraft veered left due to a strong wind gust. The aircraft fell into a ravine, coming to rest 180 degrees from the runway heading, damaging both wing spars at the fuselage attach points and collapsing the nose…NTSB FTW88LA031Accident · No injuriesLimited investigationFinal reportCessna 150 · New Orleans, LAThe pilot was attempting to start the unsecured aircraft by hand-propping it. The aircraft started and rolled forward striking a fuel truck, damaging the left wing, fuselage, and propeller.NTSB FTW88LA015Accident · Minor injuriesLimited investigationFinal reportBeech 65 · Covington, LADuring initial climb from takeoff, the left engine failed for unknown reasons. The plt stated that right rudder and aileron inputs were ineffective to stop the acft from rolling left and the acft contacted the ground as he was retarding pwr on the right eng.NTSB FTW88LA003Accident · No injuriesLimited investigationFinal reportGrumman GA7 · Covington, LAThe pilot touched down with excessive speed, and due to the poor mechanical condition of the aircraft's brakes, was unable to stop before over-running the departure end of the runway. The aircraft's annual inspection was two months overdue. The pilot's…NTSB FTW88DRD01Accident · No injuriesFinal reportGrumman G-164A · Port Allen, LAThe pilot experienced a partial loss of power during pull-up from a swath run. He attempted to return to the field he was working in order to make an emergency landing but was unable to due to inadequate engine power. He landed in high vegetation and flipped…NTSB FTW87FA223Accident · 1 fatalField investigationFinal reportPiper J3C-65 · Greenwood, LAThe pilot touched down briefly in a small clearing which he had prevously driven to by automobile. He then lifted off and started a climbout. Two separate electrical power lines were located just inside a tree line which was very close to the previously…NTSB FTW87FA222Accident · 2 fatalField investigationFinal reportErcoupe 415-D · Jackson, LAJust prior to the acdnt, witnesses observed the acft flying at low alt over a creek. They rprtd the acft went into a steep climbing left turn from about 40 to 75 ft AGL, then it entered a steep descent & crashed in the creek. No eng problems or changes in the…NTSB FTW87FA213Accident · Serious injuriesField investigationFinal reportPartenavia P68C · New Orleans, LAThe plt began an ILS rwy 18R apch at ngt to the lakefront arpt. He rprtd that after the acft broke out of the clouds at 1700', he transitioned to a visual apch. He stated that as he contd, the apch seemed normal, except the VASI lights seemed too FAR down the…NTSB FTW87DRD12Accident · Serious injuriesFinal reportPiper PA-22-150 · Mansfield, LAThe airport was 324 feet above sea level. The OAT was 96 degrees f. the airplane, with the pilot and two passengers, lifted off the rwy but would not climb. A witness stated the engine sounded normal but the nose was very high. The airplane impacted trees and…NTSB FTW87DRD13Accident · No injuriesFinal reportAir Tractor AT-400A · Monroe, LAThe ag pilot pulled up from a swath run while spraying chemicals on cotton and the pt 6A-20A engine in his aircraft exploded. A post accident teardown of the engine revealed the blades of a compressor disk had failed causing a total loss of power. Reason for…NTSB FTW87DRD11Accident · 1 fatalFinal reportGrumman G-164A · Bastrop, LAThree flagmen were working with one spray plane and three fields. On this pass, two of the flagmen moved to the proper positions but the other one had moved too FAR laterally. The pilot stated to the sheriff that he had observed the flagman stepping off the…NTSB FTW87LA195Accident · No injuriesLimited investigationFinal reportBell 206L-1 · New Iberia, LACrew performing practice touchdown autorotations during a trng flt. On 4th autorotation, acft touched down with excess grnd speed and skidded for approx 75' on the wet, soft grass. When crew applied power back to flight RPM they heard a grinding sound and…NTSB FTW87DRD14Accident · No injuriesFinal reportGrumman G-164B · Oak Grove, LAAfter completing the last pass of an agricultural operation the pilot pulled up and started a turn. At this time the engine started shaking and losing power. The pilot attempted a forced landing in a soft field. The wheels bogged four or five inches into the…NTSB FTW87DRD10Accident · No injuriesFinal reportCessna T188C · Oak Grove, LAThe pilot was attempting to take off with an over gross weight condition. The wheels left the surface only after the ground fell away into a bayou. The aircraft then remained airborne until it collided with bayou's opposite bank but did not climb during this…NTSB FTW87LA165Accident · Minor injuriesLimited investigationFinal reportBell 206L-1 · Venice, LAThe pilot was repositioning the aircraft after a phase iv inspection. The aircraft lifted off the pad and made several clockwise revolutions, descended out of control, impacted the ground and rolled over on its right side. Investigation revealed the number 1…NTSB FTW87LA164Accident · Minor injuriesLimited investigationFinal reportCessna 172I · Baton Rouge, LAThe plt rprtd that after taking off to practice touch & go lndgs, the eng lost pwr. He atmtd to make a forced lndg on the arpt, but was unable. While lndg short of the rwy, the acft hit the top of a tree & the arpt security fence. Maintenance had just been…NTSB FTW87DRD08Accident · No injuriesFinal reportGrumman G-164A · Lacassine, LAThe pilot stated the aircraft's tail wheel broke during the takeoff roll causing the aircraft to veer to the right. The right wing contacted a small tree and the right main gear wheel dropped into a ditch which was parallel with the runway. Directional…NTSB FTW87FA156Accident · 1 fatalField investigationFinal reportAerospatiale AS-355-F1 · Venice, LAOne of the mechanics who performed maintenance on the aircraft main rotor head stated that he was not sure that he installed the retaining bolts which secured the vibration absorber assembly to the aircraft. Metallurgical analysis of the assembly indicated…NTSB FTW87DRD09Accident · No injuriesFinal reportCessna T188C · Rayville, LAThe aircraft had to take off eastbound due to obstructions at the west end of the strip. The six to eight knot wind was variable from a right crosswind to a slight tailwind. Investigation revealed the aircraft's weight exceeded that established by the…NTSB FTW87DRD06Accident · 1 fatalFinal reportAir Command 532 · St.Francisville, LAWitnesses observed the gyroplane flying at 10-15 feet AGL when it started a turn to the right. It continued the right turn and descended into the ground. Dr. Moore of the FAA sw regional flight surgeon's office stated that the plt had coronary disease and…