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 SEA98FA055Accident · No injuriesField investigationFinal reportEnstrom F28F · Baker, ORFatigue failure of the steel tubing pylon structure. Factors include inadequate inspection by maintenance personnel of damage after a previous accident.NTSB MIA98FA110Accident · Serious injuriesField investigationFinal reportCessna 150H · West Palm Beach, FLThe poor in-flight planning by the pilot-in-command for his failure to ask for assistance after becoming lost momentarily, and his failure to monitor the total time airborne after the fuel tanks were filled. Contributing to the accident was the binding of the…NTSB FTW98LA160Accident · Minor injuriesLimited investigationFinal reportAero Commander 100 · Fort Worth, TXThe separation of the aileron control rod due to bending overstress. A factor was the unsuitable terrain available for the precautionary landing.NTSB FTW98IA158Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-10-10 · Denver, COThe total failure of one main landing gear tire.NTSB FTW98LA148Accident · No injuriesLimited investigationFinal reportBeech 58 · Taos, NMThe total failure of the landing gear retraction/extension assembly for reasons undetermined.NTSB NYC98LA076Accident · No injuriesLimited investigationFinal reportEnstrom F-28A · Blue Ash, OHThe failure of a cooling fan blade and the pilot's improper flare.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 ANC98IA026Incident · No injuriesIncident investigationFinal reportBoeing 737-205 · Anchorage, AKThe dynamic imbalance in the yaw rate gyro, which provided input to the yaw damper and rudder. A factor was the deteriorated grease in the gyro bearings.NTSB MIA98IA100Incident · No injuriesIncident investigationFinal reportAerospatiale ATR-42-300 · Fort Myers, FLThe failure of the No. 1 generator field excitation return wire terminal lug due to improper installation of the field excitation return wire by maintenance personnel; the subsequent failure of the No. 2 generator due to overvoltage, caused by the momentary…NTSB FTW98FA145Accident · 1 fatalField investigationFinal reportDuci'S Vans RV-3 · Elbert, COin-flight failure of the right wing spar (for an undetermined reason) as the pilot was performing aerobatic flight. The airplane's excessive gross weight (for aerobatics) was a related factor.NTSB LAX98LA108Accident · Serious injuriesLimited investigationFinal reportBell UH-1B · Hollister, CAThe failure of the maintenance personnel to recognize and repair the chafed area of the tail rotor driveshaft, which resulted in an in-flight separation of the tail fin and hub assembly.NTSB MIA98LA096Accident · Serious injuriesLimited investigationFinal reportDouglas DC-10-30F · Memphis, TNground personnel (an equipment loader) failed to follow established written procedures (ramp safety policy), resulting in a pressurized entry door being opened before it was fully depressurized, subsequently injurying the equipment loader. The malfunctioning…NTSB NYC98FA073Accident · 2 fatalField investigationFinal reportPiper PA-23-160 · Somerville, NJin-flight separation of the empennage for undetermined reasons. "This case was modified August 2, 2006."NTSB MIA98LA092Accident · No injuriesLimited investigationFinal reportCessna 188B · Houston, MScorrosion and subsequent disconnect of the left aileron control rod end fitting, which resulted in a loss of aileron (roll) control, a forced landing, and subsequent impact with the terrain. A factor related to the accident was: improper lubrication of the…NTSB FTW98LA134Accident · Minor injuriesLimited investigationFinal reportBurchinal A4D-2 · Fort Worth, TXA total hydraulic system failure for an undetermined reason.NTSB MIA98LA084Accident · 1 fatalLimited investigationFinal reportWalter J Collie Cumulus · Hillsboro, TNDebonding of the leading edge to spar cap joint, which resulted in inflight separation.NTSB FTW98LA139Accident · No injuriesLimited investigationFinal reportPiper PA-46-350P · Dallas, TXThe nose gear collapsed for an undetermined reason. A factor was the total electrical failure due to the separation of the alternator output lugs resulting from inadequate maintenance.NTSB ANC98LA017Accident · No injuriesLimited investigationFinal reportCessna 185E · Anchorage, AKA separation of the axle from the landing gear strut due to overload, and stripping of the axle bolt threads.NTSB FTW98IA130Incident · No injuriesIncident investigationFinal reportSaab-Scania 340B · Lawton, OKthe collapse of the left main landing gear during landing roll as result of a shorted weight-on-wheels relay. Contributing factors were the insufficient information available to the flight crew in the company's quick reference handbook (QRH), and the…NTSB CHI98IA095Incident · No injuriesIncident investigationFinal reportAirbus Industrie A-320-212 · Memphis, TNthe inadequate (bronze) material used by the fuel pump's manufacturer, which wore and ultimately blocked the fuel filter bypass and partially blocked the fuel nozzles, causing the fuel spray to burn through the low pressure turbine case.NTSB FTW98LA118Accident · No injuriesLimited investigationFinal reportCessna 172M · Bulverde, TXThe pilot's failure to maintain the proper glidepath following a total electrical failure resulting from an inoperative voltage regulator. Factors were the dark night conditions, the pilot's lack of experience in night flying, and the trees.NTSB CHI98LA091Accident · No injuriesLimited investigationFinal reportCessna 210G · Springfield, ILThe failure of left main landing gear saddle resulting in the pilot's inability to extend the left gear. A factor was maintenance personnel's failure to comply with the related airworthiness directive.NTSB FTW98LA124Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Frederick, OKThe loss of wheel brakes due to the failure of the brake actuating cable. A factor was the tailwind.NTSB CHI98FA086Accident · 2 fatalField investigationFinal reportPiper PA-28-160 · Faribault, MNwas the pilot's patial incapacitation due to carbon monoxide poisoning. A factor associated with this accident was the mechanic's inadequate inspection of the airplane's muffler and inadequate preflight planning and preparation by the pilot.NTSB FTW98LA109Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Alexandria, LAThe fire in the normal braking system due to an undetermined reason.NTSB MIA98LA078Accident · No injuriesLimited investigationFinal reportLake LA-4-200 · Sarasota, FLinadequate clearance and fretting wear of the fitting/beam attachment to the angle/top beam, due to inadequate design, which resulted in fatigue and subsequent failure of the fitting/beam attachment ear.NTSB ATL98IA039Incident · No injuriesIncident investigationFinal reportRobinson R-44 · Miami, FLAn inadequate service bulletin which did not require measurement of the cyclic trim assembly shaft and did not identify all helicopters in which shaft wear could lead to restricted movement of the lateral cyclic trim.NTSB NYC98FA062Accident · Minor injuriesField investigationFinal reportAerospatiale ATR-42-320 · Windsor Locks, CTThe improper overhaul of lug holes on the fuel/oil heat exchanger. A factor was the lack of direction contained in the manufacturer's overhaul manual for working with the lug holes.NTSB FTW98TA104Accident · Minor injuriesFinal reportHughes 269C · Brackettville, TXfailure of splines on the drive shaft coupling after separation of the forward bubber boot and loss of lubrication (grease), which resulted in a disconnect of the rotor drive system and an autorotation/forced landing. Lack of suitable terrain in the forced…NTSB ATL98LA031Accident · No injuriesLimited investigationFinal reportChristopher Coats Challenger II · Evergreen, ALThe undetermined failure of the propeller bolts that resulted in the inflight separation of the propeller assembly. A factor was the overpass bridge.NTSB FTW98MA096Accident · 2 fatalMajor investigationFinal reportGates Learjet 25B · Houston, TXThe flight crew's continued descent of the airplane below the glideslope and through the published decision height without visual contact with the runway environment. Also, when the captain encountered difficulty tracking the localizer course, his improper…NTSB FTW98FA089Accident · Serious injuriesField investigationFinal reportCameron R-420 · Yeso, NMThe rupture of the gas cell bottom (diaphragm) due to inadequate manufacturer's design and inadequate manufacturing quality control. A factor was the flight crew's performance of an emergency bailout which allowed the balloon to drift unattended for…NTSB ANC98LA014Accident · No injuriesLimited investigationFinal reportDouglas DC-6B · Mcgrath, AKThe ingestion of snow into the windshield anti-ice system, and the resulting obscured windshield which made runway alignment not possible. Factors associated with this accident were the cold windshield, the reduced performance of the windshield anti-ice…NTSB FTW98LA071Accident · Serious injuriesLimited investigationFinal reportUnknown Quicksilver GT-500 · San Antonio, TXthe kitplane builder's improper installation of the bolts attaching the left leading edge wing strut fitting to the leading edge spar, which resulted in the eventual failure of the fitting and the ensuing loss of control. Related factors were: the…NTSB LAX98IA061Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas MD-80 · San Francisco, CAAn emergency evacuation due to fumes from a failed hydraulic line that entered into the cabin.NTSB ATL98LA019Accident · 2 fatalLimited investigationFinal reportSiggi's Airplane Works D-4 Fascination · Leesburg, FLstructural failure of the right wing, during the initial climb after takeoff, which resulted in an uncontrolled descent to the ground.NTSB FTW98LA060Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Lubbock, TXThe inadequate maintenance of the landing gear assembly by maintenance personnel resulting in a partial gear extension, and the pilot's misjudgment of a proper touchdown point to intentionally shut down the engine resulting in the airplane landing short of…NTSB FTW98LA059Accident · No injuriesLimited investigationFinal reportMooney M20F · Stuttgart, ARthe pilot's failure to activate the runway lights, which led to his selection of a closed/abandoned runway for the landing. Factors relating to the accident were: the unlatched cabin door, and the lack of lighting conditions at dusk.NTSB ATL98FA017Accident · 4 fatalField investigationFinal reportMark Ewart Velocity Standard RG · Florence, SCimproper maintenance procedures used by the pilot/repairman, which resulted in the loosening and eventual failure of the propeller. Factors relating to the accident were: the pilot's self-imposed pressure to hurry to the destination, and trees in the forced…NTSB SEA98LA017Accident · Minor injuriesLimited investigationFinal reportBell TH-1L · Canby, ORThe pilot's allowance of excessive airspeed resulting in the long-line hook impacting the tail rotor, and his allowance of an airspeed bleed-off preventing a successful run-on landing due to a loss of yaw control.NTSB FTW98LA055Accident · Minor injuriesLimited investigationFinal reportPiper PA-32RT-300T · Midlothian, TXfatigue failure of the #2 cylinder fuel injection line in an area where the line was previously damaged, which resulted in an in-flight engine compartment fire and a forced landing. Related factors were: the previous damage of the fuel injector line, and the…NTSB ATL98LA022Accident · No injuriesLimited investigationFinal reportChristen Industries S-2B · Fort Lauderdale, FLThe undetermined malfunction of the right brake and the pilot's failure to maintain directional control during the landing rollout. A factor was the quartering tailwind.NTSB MIA98IA035Incident · No injuriesIncident investigationFinal reportDouglas DC-8F-55 · Miami, FLThe inadequate overhaul of the No. 4 engine start valve resulting in the valve remaining open after engine start; and the subsequent free run state of the starter resulting in a starter overheat, disintegration and fire.NTSB CHI98LA040Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Salem, INthe pilot's misjudgment of distance and altitude, while on final approach to land at night. Factors relating to the accident included: an undetermined electrical malfunction, inoperative flaps, darkness, the pilot not using the landing light, and the…NTSB MIA98LA027Accident · No injuriesLimited investigationFinal reportNaval Aircraft Factory N3N-3 · Spruce Pine, NCThe unintentional locking-up of the left brake for undetermined reasons resulting in the on ground loss of control. Contributing to the accident was the inability of the pilot to maintain directional control.NTSB CHI98IA035Incident · No injuriesIncident investigationFinal reportCessna 152 · Blaine, MNthe fracture of the flap cable as a result of fatigue cracking.NTSB LAX98LA034Accident · No injuriesLimited investigationFinal reportGlobe GC-1B · Los Angeles, CAThe pilot's loss of directional control due to an inadvertent ground loop resulting from a deflated tire.NTSB MIA98FA025Accident · No injuriesField investigationFinal reportFokker F100 · Charlotte, NCImproper written instructions (job/task card) by company maintenance personnel. The procedures did not reflect the correct manufactures maintenance manual servicing procedure, and did not ensure that the proper tool (replenishing gun) was available for the…NTSB FTW98FA044Accident · 1 fatalField investigationFinal reportPiper PA-34-200T · Myton, UTThe pilot exceeded the design stress limits of the airplane which resulted in an in-flight airframe overload failure. A related factor was the dark night.NTSB CHI98LA032Accident · No injuriesLimited investigationFinal reportCessna 421A · Tomahawk, WIthe elevator trim tab bolt backed out, allowing the trim tab to flutter, and destroy the elevator. The factors involved were improper annual inspection by the maintenance personnel, and the inadequate aircraft preflight done by the pilot.