NTSB investigations
3,929 cases where the first occurrence was “Airframe/component/system failure/malfunction”.
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.\"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."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 CHI92LA281Accident · No injuriesLimited investigationFinal reportCessna 172RG · Wheeling, ILMain landing gear collapse as a result of the failure of a landing gear hydraulic pump seal.NTSB LAX92FA374Accident · 2 fatalField investigationFinal reportPiper PA-23-160 · Concord, CAThe following Probable Cause was modified on April18, 2007, as a result of new information provided to the NTSB. The improper installation of the 1.75 inch od plug in the crankshaft by unknown maintenance personnel which resulted in an inadvertent feathering…NTSB ATL92IA169Incident · No injuriesIncident investigationFinal reportSaab-Scania 340B · Chattanooga, TNThe failure and subsequent seizure of the reduction gear box, and the failure of the propeller control unit as a result of contaminated oil supply which is shared with the gear box.NTSB ANC92IA147Incident · No injuriesIncident investigationFinal reportShort Brothers SH-7 · Sheldon Point, AKThe unlatching of the left crew entrance door by means undetermined and the lack of adherence to door check items by the pilot in command on the requisite checklists. A factor relating to the incident was the separation of the door from the frame when opened…NTSB CHI92IA260Incident · No injuriesIncident investigationFinal reportDouglas DC-8-61 · Morton Grove, ILFailure of the right main landing gear door actuator.NTSB MIA92LA167Accident · Serious injuriesLimited investigationFinal reportBoeing 737-200 · Miami, FLFailure (short) of a diode located inside a transformer which is located in the no. 1 generator control unit.NTSB ANC92GA155Accident · No injuriesFinal reportBell 206B · Fairbanks, AKPoor maintenance and inspection procedures by the contract maintenance personnel, as well as improper maintenance and installation of the fuel line by the contract maintenance personnel. Factors relating to the accident were the turboshaft engine vibrations…NTSB MIA92IA166Incident · No injuriesIncident investigationFinal reportDouglas DC-8-71F · Miami, FLFailure of the aircraft operator maintenance personnel to adequately lubricate and seal the main landing gear bogie beam swivel joint as required by manufacturer and operator maintenance program requirements. This allowed moisture to enter the swivel joint…NTSB FTW92FA215Accident · Minor injuriesField investigationFinal reportBell XV-15 301 · Arlington, TXInadequate maintenance and inspection which resulted in a disconnected proprotor governor linkage.NTSB NYC92LA170Accident · No injuriesLimited investigationFinal reportGerald Barker Quicky 2 · Altoona, PAAn onground collision with a VASI light box after the tailwheel strut broke upon touchdown and the pilot lost directional control.NTSB NYC92LA166Accident · No injuriesLimited investigationFinal reportMitsubishi MU-2-60 · Philadelphia, PAThe in-flight separation of a propeller blade as a result of fatigue cracking initiated from multiple sites located at corrosion pits in the balancing hole. Contributing factors in the accident were: the failure to detect the corrosion during the last…NTSB FTW92LA210Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Russellville, ARThe pilot's improper flare. Factors were the propeller system's pitch change mechanism disconnected due to improper overhaul and failure to install the staking pins by other maintenance personnel.NTSB LAX92LA349Accident · Minor injuriesLimited investigationFinal reportHiller UH12-E, Saloy Conver · Arvin, CAThe failure of the tension torsion bar pin due to fatigue. Contributing to this accident was that it was not possible for the pilot to flare the helicopter on landing.NTSB NYC92FA161Accident · 3 fatalField investigationFinal reportPiper PA-28R-180 · Bradford, NYA mechanical malfunction of the artificial horizon in IMC that resulted in spatial disorientation of the pilot and his inability to maintain airplane orientation. A factor in the accident was the improper maintenance of the artificial horizon.NTSB NYC92LA163Accident · No injuriesLimited investigationFinal reportPiper J-3 · Portsmouth, OHThe failure of the propeller leading edge as the result of corrosion and the subsequent forced landing on unsuitable terrain.NTSB NYC92LA162Accident · No injuriesLimited investigationFinal reportPiper PA-18A-150 · Ocean City, NJThe airplane nosing over on landing roll due to inadequate airplane handling characteristics while landing with the banner attached. Factors related to the accident were the use of rope instead of steel cable, the main landing gear mounted tow hitch, and the…NTSB LAX92LA343Accident · Serious injuriesLimited investigationFinal reportBurkhart Grob 103 · Truckee, CAThe inadequate aircraft maintenance and flight manuals and unavailable information pertaining to the inspection of the spoiler system. Contributing to this accident was the worn and jammed spoiler attachment limiting block.NTSB NYC92LA151Accident · Minor injuriesLimited investigationFinal reportRockwell 112-TC · St Mary'S, WVThe fatigue cracking fracture of the propeller hub, resulting in a forced landing, and collision with a house.NTSB LAX92LA344Accident · No injuriesLimited investigationFinal reportCessna 320A · Novato, CAThe locked left brake assembly due to the missing brake retaining clips.NTSB LAX92LA338Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Parker, AZThe inadequate overhaul of the propeller blade by the overhaul facility. Contributing to this accident was the rough and uneven terrain.NTSB NYC92GA147Accident · Serious injuriesFinal reportSikorsky S-76A · Graefenburg, KYAn inadequate preflight inspection by the flight crew by failing to assure that all four of the engine cowling latches were properly secured, which resulted in subsequent failure of section ii of the tail rotor driveshaft after the cowling contacted the main…NTSB LAX92FA331Accident · 1 fatalField investigationFinal reportCessna 152 · Maricopa, AZThe pilot exceeded the design stress limits of the airplane structure by attempting an abrupt maneuver at a speed in excess of the maneuvering speed.NTSB CHI92FA223Accident · 2 fatalField investigationFinal reportEdra/Mcdermitt Seabird/Petrel · Oshkosh, WIInadequate quality control during the manufacturing process resulting in the in-flight structural failure of the tailboom.NTSB CHI92DEX04Accident · Minor injuriesFinal reportAlkire Pietenpol · Delphi, INSeparation of the propeller while in flight, and unsuitable terrain to effect a forced landing.NTSB DCA92MA044Accident · Serious injuriesClass 1 · MajorFinal reportLockheed L-1011-385-1 · Jamaica, NYDesign deficiencies in the stall warning system that permitted a defect to go undetected, the failure of twa's maintenance program to correct a repetitive malfunction of the stall warning system, and inadequate crew coordination between the captain and first…NTSB LAX92LA319Accident · Minor injuriesLimited investigationFinal reportBell UH-1B · Hayfork, CAThe failure of the main rotor drive shaft due to the improper installation by company maintenance personnel of an 'o' ring seal, which allowed the packing grease to escape and caused the over temperature failure of the drive shaft. A factor in the accident…NTSB CHI92LA213Accident · No injuriesLimited investigationFinal reportBeech H35 · Baraboo, WIInadequate maintenance service and aircraft preflight by the pilot. A factor contributing to this accident was a partial failure of the brake system.NTSB ATL92LA145Accident · No injuriesLimited investigationFinal reportCessna 180B · Monroe, GAFailure of the pilot's seat assembly for an undetermined reason(s) which resulted in a loss of control during the takeoff roll.NTSB FTW92LA185Accident · No injuriesLimited investigationFinal reportBeech D55 · Pineville, LAThe mechanical binding of the yoke after liftoff.NTSB DEN92IA074Incident · No injuriesIncident investigationFinal reportEmbraer EMB-120 RT · Denver, COOpen air ground circuit breakers that allowed the propellers to overspeed. A factor was: clear air turbulence.NTSB CHI92DEX03Accident · 1 fatalFinal reportPiper PA-25-260 · Decker, INFailure of the right wing spar, improper maintenance/modification, and failure to comply with an airworthiness directive.NTSB CHI92LA209Accident · No injuriesLimited investigationFinal reportBeech E35 · Escanaba, MIThe pilot's decision to fly into known adverse weather conditions.NTSB ATL92LA140Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Shallotte, NCThe deterioration of the left main fuel bladder which resulted in the premature exhaustion of the fuel supply and the loss of engine power. A factor was soft terrain.NTSB FTW92IA184Incident · No injuriesIncident investigationFinal reportBoeing 737-222 · Oklahoma City, OKHydraulic fluid exhaustion due to the chafed 'a' system hydraulic line and the improper installation by unknown maintenance personnel of the 'b' system line.NTSB CHI92LA207Accident · No injuriesLimited investigationFinal reportCessna 172N · Bates City, MOTotal failure of the airplane windshield.NTSB BFO92FA093Accident · 1 fatalField investigationFinal reportCessna U206F · Portland, MEImproper in-flight planning/decision by the pilot, resulting in fuel starvation due to improper positioning of the fuel selector. Factors related to the accident were: an undetermined electrical failure, and loss of fuel quantity indication.NTSB DEN92IA072Incident · No injuriesIncident investigationFinal reportPiper PA-34-200T · Lamar, COFractured nose landing gear bolt due to fatigue.NTSB LAX92LA282Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Montague, CAThe disintegration of the left wheel during the landing roll out and the resultant inability of the pilot to maintain directional control of the aircraft. A factor in the accident was the soft nature of the terrain encountered by the aircraft after leaving…NTSB CHI92DCD08Accident · Minor injuriesFinal reportJohn Schackel Q2 · Rutland, IAA fatigue failure of the engine crankshaft during cruise flight.NTSB CHI92DCQ05Accident · Serious injuriesFinal reportVirgil Larson Varieze,LONG EZ · Chanute, KSA delamination and inflight separation of a propeller blade during cruise flight.NTSB ATL92LA133Accident · No injuriesLimited investigationFinal reportCessna 402B · Tuscaloosa, ALThe improper installation of the emergency exit, by an unknown person, which resulted in its separation, in flight.NTSB MIA92IA141Incident · No injuriesIncident investigationFinal reportCASA 212 · Mayaguez, PRFailure of the nosegear assembly steering actuator due to play at the lower trunnion, which caused a vibration, failure of the steering actuator, subsequent on ground loss of control, and on-ground collision with a sign during landing rollout.NTSB SEA92LA131Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Corbett, ORThe failure of the float attach fitting, and the separation of the floats from the aircraft.NTSB SEA92IA136Incident · No injuriesIncident investigationFinal reportFokker F.28 MK 1000 · Portland, ORThe partial failure of the horizontal stabilizer trim drive system, the restricted movement of the stabilizer, and the overtorque of a system component.NTSB CHI92LA185Accident · No injuriesLimited investigationFinal reportCessna 150H · Three Rivers, MIThe pilot-in-command's selection of a rough and uneven terrain. A factor related to the accident was the pilot-in-command's poor inflight decision making.NTSB FTW92FA165Accident · 2 fatalField investigationFinal reportPiper J3C-65 · Addison, TXFailure of the left elevator assembly due to corrosion.NTSB ANC92LA093Accident · No injuriesLimited investigationFinal reportCessna 185F · Talkeetna, AKFailure to maintain directional control. Factors include tailwheel vibration/shimmy, and an inadvertent ground loop.NTSB MIA92LA139Accident · No injuriesLimited investigationFinal reportExtra Flugzeugbau 300 · Titusville, FLSeparation of the propeller governor cover from the body for undetermined reasons and visual restriction of the pilot due to leaking oil which covered the windscreen.NTSB NYC92LA119Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Felton, PAA precautionary landing in unsuitable terrain. An additional cause was the failure of the mechanic to tighten the oil return line on the number three cylinder. A factor related to the accident was the pressure the mechanic felt to complete the job in a timely…NTSB FTW92LA155Accident · No injuriesLimited investigationFinal reportSikorsky S-76A · Morgan City, LAThe second pilot's failure to maintain aircraft control.