NTSB investigations, LA
75 cases where the first occurrence was “Airframe/component/system failure/malfunction”.
Cases per year
| 1982 | 12 |
|---|---|
| 1983 | 6 |
| 1984 | 4 |
| 1985 | 7 |
| 1986 | 2 |
| 1987 | 3 |
| 1988 | 6 |
| 1989 | 2 |
| 1990 | 2 |
| 1991 | 2 |
| 1992 | 3 |
| 1993 | 4 |
| 1995 | 2 |
| 1996 | 2 |
| 1997 | 2 |
| 1998 | 4 |
| 1999 | 2 |
| 2000 | 2 |
| 2001 | 1 |
| 2003 | 3 |
| 2005 | 1 |
| 2006 | 2 |
| 2007 | 1 |
Where
Open the mapLatest cases
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'
AND c.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 130)
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' AND c."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 130) 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 DFW07FA198Accident · 2 fatalField investigationFinal reportFairchild Hiller FH-1100 · Hosston, LAThe in-flight separation of the main rotor mast while in cruise flight following a mast bumping event. The reason for the mast bumping event was not determined.NTSB DFW06LA097Accident · Serious injuriesLimited investigationFinal reportRocket Flyers Turbine Legend · Hammond, LAThe reported loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW06LA094Accident · No injuriesLimited investigationFinal reportAviation Specialties Unlimited Challenger II · Coushatta, LAThe loss of control due to premature failure of the elevator's push-pull tube rod-end bearing.NTSB DFW05LA147Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Lake Charles, LAThe failure of the propeller governor which resulted in a forced landing. A contributing factor was the transmission wire.NTSB FTW03FA117Accident · No injuriesField investigationFinal reportBell 407 · Houma, LAThe loss of tail rotor drive and anti-torque control resulting from the fracture and separation of the #5 tail rotor drive segment due to the overtemperature and subsequent failure of the #5 hangar bearing.NTSB FTW03LA102Accident · No injuriesLimited investigationFinal reportEnstrom 280FX · Ruston, LAThe separation of the upper tail cone as a result of a fractured bolt due to fatigue.NTSB FTW03LA081Accident · Minor injuriesLimited investigationFinal reportAerospatiale AS-350-BA · Venice, LAThe loss of tail rotor drive as a result of baggage coming in contact with the tail rotor blades after the aft cargo door was not secured. A contributing factor was the passenger's failure to follow the procedures for properly securing the helicopter's doors…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 FTW00LA153Accident · Minor injuriesLimited investigationFinal reportEurocopter AS350B2 · Patterson, LAthe failure of the tail rotor spider bearing, the pilot's failure to follow the proper emergency procedures as stated in the helicopter's checklist by not performing a run-on landing, and the inadvertent deactivation of the hydraulic system.NTSB FTW00LA149Accident · Serious injuriesLimited investigationFinal reportPZL-Mielec M-18A · Kilbourne, LAThe corrosion and fatigue cracking of the right wing attachment fitting, which resulted in the right wing separating in flight.NTSB FTW00LA055Accident · No injuriesLimited investigationFinal reportCessna 172L · New Orleans, LAThe pilot's inadvertent starting of the engine. Factors were the pilot's failure to set the mixture control to the off position, and the intermittent short in the starter switch.NTSB FTW99LA170Accident · Minor injuriesLimited investigationFinal reportWsk Pzl Mielec M-18A · Basile, LAThe separation of the right wing forward spar lower attachment fitting due to a fatigue fracture, which emanated from corrosion as a result of maintenance not being performed.NTSB FTW98LA280Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Shreveport, LAThe collapsed nose gear as a result of failure of the nose gear locking mechanism.NTSB FTW98FA170Accident · 3 fatalField investigationFinal reportPiper PA-28-235 · New Orleans, LAThe pilot's inability to maintain control of the airplane after experiencing spatial disorientation. Factors were the total failure of the vacuum pump, fog, drizzle, and night conditions.NTSB FTW98LA144Accident · Minor injuriesLimited investigationFinal reportBell 47D1 · Jeanerette, LAThe in-flight disconnect of the rotating scissors due to the separation of its hinge bolt.NTSB FTW98LA109Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Alexandria, LAThe fire in the normal braking system due to an undetermined reason.NTSB FTW97LA326Accident · No injuriesLimited investigationFinal reportBell 206B · Oak Grove, LAThe disconnect of the #5 tail rotor drive segment due to the debonding of the joint between the shaft tube and the flange fitting. Factors were the improper bead blasting of the tail rotor drive segment by an unknown maintenance personnel, and the lack of…NTSB FTW97IA305Incident · No injuriesIncident investigationFinal reportSaab-Scania 340B · Lafayette, LAThe failure of the AC generator due to the failure of the anti-drive end bearing.NTSB FTW96FA319Accident · 2 fatalField investigationFinal reportChester Glasair RG · Lafayette, LAfailure of the pilot to maintain proper altitude (and clearance above wooded terrain), while diverting to an alternate destination. Factors relating to the accident were: the loss of the comm/nav equipment as a result of an electrostatic discharge, darkness,…NTSB FTW96FA151Accident · 1 fatalField investigationFinal reportSukhoi SU-29 · New Orleans, LAThe in-flight loss of a bolt in the elevator control system due to improper installation by unknown person(s), which resulted in a disconnection of the elevator control system that rendered the airplane uncontrollable.NTSB FTW95IA397Incident · No injuriesIncident investigationFinal reportMBB BO-105C · Lafayette, LAa short in the 'jam proof system' solenoid valve which prevented activation of the backup hydraulic system and resulting in a cyclic hardover. Factors were the contaminated hydraulic fluid and the resulting jammed actuator (longitudinal control slider).NTSB FTW95LA240Accident · No injuriesLimited investigationFinal reportAyres S2R-T34 · Iowa, LAThe failure of the right brake due to the hydraulic fluid leaking. Factors were proper alignment not possible and the close proximity of the ditch.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.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.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.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 FTW92LA185Accident · No injuriesLimited investigationFinal reportBeech D55 · Pineville, LAThe mechanical binding of the yoke after liftoff.NTSB FTW92LA155Accident · No injuriesLimited investigationFinal reportSikorsky S-76A · Morgan City, LAThe second pilot's failure to maintain aircraft control.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 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 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 FTW90DRD04Accident · No injuriesFinal reportGrumman G-164B · Fenton, LAFailure of the elevator control rod end bearing.NTSB FTW90DRD02Accident · No injuriesFinal reportC&J Sontheimer Rotorway · Lake Charles, LAFailure of the tail rotor drive belt.NTSB FTW89DRD14Accident · No injuriesFinal reportGrumman G-164A · Franklin, LAFatigue failure of the propeller blade, which resulted in separation of the blade's tip and severe engine vibration. The soft terrain was a related factor.NTSB FTW89FA143Accident · 1 fatalField investigationFinal reportBalloon Works Firefly 6B · Baton Rouge, LAThe pilot exceeded the temperature limitations of the Balloon during the climb, which resulted in failure of the frabric. Factors related to the accident were: the previous heat damage to the frabric, and the lack of maintenance by the pilot/owner.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 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 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 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 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 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 LAX86MA309Accident · No injuriesMajor investigationFinal reportAerospatiale AS-355F-1 · Morgan City, LAThe plt flew to a nearby arpt to practice takeoffs & lndgs. He rprtd that after 3 lndgs 'out of a hover,' he returned to the departure heliport & lndd again from a hover. Drg touchdown, the helicopter bgn to rock fm side to side & enteredground resonance. The…NTSB FTW86FA116Accident · 1 fatalField investigationFinal reportMBB 105 · Houma, LAA fatigue failure in a main rotor blade pitch change link resulted in the loss of control of one blade, leading to an in flight separation of the tail boom. The helicopter was uncontrollable and pitched forward, impacting the ground inverted.NTSB FTW86FA023Accident · 2 fatalField investigationFinal reportCessna 152 · Arcadia, LAThe instrument flight instructor and student experienced a directional gyro failure. They covered the instrument and requested a return to their departure point. The aircraft was not equipped to fly the published approach. They requested a descent to an…NTSB FTW86FA016Accident · No injuriesField investigationFinal reportBell 222A · Charenton, LAThe helicopter had just completed a phase two check, twenty minutes into the flight the occupants heard a loud noise and a severe one-to-one vibration ensued. A successful emergency landing was performed. Examination revealed that one swash plate drive link…NTSB FTW85FRD01Accident · Serious injuriesFinal reportAlon A-2 · Bunkie, LAThe acft contacted the terrain and was destroyed by fire following a loss of elevator and aileron control. The plt reported he maintained control of the acft by use of the rudder, pwr and elevator trim. Post accident inspection revealed the left aileron…NTSB FTW85LA201Accident · Serious injuriesLimited investigationFinal reportCessna 170B · Ama, LAThe aircraft reportedly assumed an abrupt nose high attitude during its initial climb following takeoff. The pilot stated he made the initial left departure turn from the airport and then realized he could not release the elevator back pressure he had used…