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 LAX93LA120Accident · No injuriesLimited investigationFinal reportBell 47G · Bakersfield, CAThe clutch slippage and failure of the pilot to jettison the load.NTSB CHI93IA078Incident · No injuriesIncident investigationFinal reportFokker F-28 MK 1000 · Detroit, MIImproper lubrication of the horizontal stabilizer gearbox by company maintenance personnel. A factor was the manufacturer's inadequate service procedure.NTSB LAX93LA104Accident · 4 fatalLimited investigationFinal reportFairchild Hiller FH-1100 · Volcano Natl Pk, HIA loss of tail rotor control for an undetermined reason(s). A factor which contributed to the accident was the pilot's choice of a hover altitude/position inadequate to reach a shoreline in the event of an emergency. A factor which contributed to the severity…NTSB LAX93FA095Accident · 2 fatalField investigationFinal reportCessna 414 · Reno, NVThe failure of the pilot to use pitot static system covers during icing conditions which resulted in a blocked pitot tube and subsequent loss of airspeed indications. This led to pilot disorientation and an invertant stall. Factors to the accident were…NTSB ATL93LA050Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301 · Goldsboro, NCThe pilot's improper decision in attempting a night landing at an airport without operating runway lights which resulted in a touchdown off the runway. Factors which contributed to the accident were: an airplane lighting malfunction for an undetermined…NTSB BFO93LA020Accident · No injuriesLimited investigationFinal reportDornier DO-228-202 · Manchester, NHIncorrect installation of the seals in the nose gear assembly, which prevented the nose gear from locking in the down position.NTSB CHI93IA069Incident · No injuriesIncident investigationFinal reportde Havilland DHC-8-311 · Savoy, ILThe total failure of the inboard right main landing gear wheel axle during the initial climb.NTSB ATL93LA049Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Crossville, TNThe pilot's failure to follow checklist procedures in that he did not utilize the alternate gear extension method when electrical power was lost. A factor was his failure to follow the checklist when he failed to turn on the generators prior to flight, which…NTSB CHI93IA060Incident · No injuriesIncident investigationFinal reportBeech B90 · Sioux Falls, SDThe pilot-in-command's inadequate preflight.NTSB SEA93LA045Accident · No injuriesLimited investigationFinal reportCroy KR-2M · Gillette, WYJamming of the nose landing gear door opening mechanism and the pilot in command's excessive descent rate upon touchdown.NTSB SEA93LA038Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Arco, IDA leaking crankshaft oil seal, and snow on the landing area.NTSB ANC93LA021Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Anchorage, AKThe total loss of engine power due to a short in the voltage regulator, and the lack of suitable terrain for the pilot to make the forced landing on.NTSB CHI93FA050Accident · 1 fatalField investigationFinal reportCessna 177B · Kansas City, MOThe pilot-in-command's failure to maintain a positive rate of climb during a missed approach. Factors which contributed to the accident were: inoperative gyro instruments due to a broken vacuum pump, the dark night, adverse weather conditions, and rising…NTSB SEA93FA032Accident · 1 fatalField investigationFinal reportCessna 152 · Marysville, WAThe design stress limits of the airframe were exceeded by the student pilot.NTSB LAX93LA058Accident · No injuriesLimited investigationFinal reportRobinson R-22 Beta · Fresno, CAThe pilot's inadequate preflight. Contributing to this accident was the separation of the fuel cap, tail rotor blade balance weight, tail rotor gear box, and the vertical fin.NTSB FTW93LA047Accident · No injuriesLimited investigationFinal reportHiller UH12B · Justin, TXFailure of the main rotor system for undetermined reasons. A factor was the lack of suitable terrain at the pilot's disposal.NTSB CHI93GA046Accident · 2 fatalFinal reportSchweizer 269C · Kansas City, MOThe pilot-in-command's misjudging the distance during the autorotation.NTSB MIA93LA022Accident · Minor injuriesLimited investigationFinal reportMason, Jack A. Velocity · Crystal River, FLFailure of an unknown individual to determine that the propeller was properly secured after removal of the propeller spinner, resulting in separation of one of the propeller blades during cruise flight. Contributing to the accident was unsuitable terrain…NTSB MIA93LA039Accident · No injuriesLimited investigationFinal reportPiper PA-32-301 · Dorado, PRPoor in flight planning decision by the pilot in command. Contributing to the accident was the partial blockage of the pitot static system and incorrect airspeed indicator.NTSB LAX93LA044Accident · No injuriesLimited investigationFinal reportHughes 369D · Carlsbad, CAFailure of the overrunning clutch assembly bearing for undetermined reasons.NTSB LAX93FA033Accident · No injuriesField investigationFinal reportSabreliner N-265-60 · Phoenix, AZThe delay of the PIC to apply normal braking and his failure to execute the appropriate emergency procedures. Contributing to this accident was an undetermined antiskid malfunction; the copilot's inexperience in the aircraft; and inadequate crew coordination.NTSB LAX93IA029Incident · No injuriesIncident investigationFinal reportPiper PA-31T-620 · Medford, ORFatigue failure of the elevator control tube rod end bearing resulting in a loss of elevator control.NTSB SEA93LA019Accident · No injuriesLimited investigationFinal reportBeech A35 · Vancouver, WADesign stress limits of the aircraft were exceeded.NTSB CHI93LA015Accident · No injuriesLimited investigationFinal reportBeech K35 · Scott City, KSFailure of the alternator and the pilot's inadvertent descent.NTSB LAX93LA017Accident · 1 fatalLimited investigationFinal reportPasporello, J.F. RV-3 · Lompoc, CAThe failure of an unidentified airframe or component system for unknown reasons and the resulting inflight fire.NTSB DEN93LA006Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Grand Junction, COFatigue failure of the nose landing gear upper drag strut bracket due to fatigue cracking.NTSB ATL93LA013Accident · No injuriesLimited investigationFinal reportPatrick F. Bowers Corbin JR. ACE E · Woodstock, GAThe separation of the propeller from the aircraft.NTSB DEN93IA005Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-9-82 · Denver, COAn inadvertent attempt, by unknown persons, to start the APU which had been placarded as inoperative. Factors were: inadequate procedures in rendering the APU incapable of being started when inoperative.NTSB FTW93LA007Accident · No injuriesLimited investigationFinal reportCessna 210G · Little Rock, ARThe partial failure of the landing gear retraction/extension assembly from restricted hydraulic fluid movement through a partially failed main landing gear uplock release valve.NTSB SEA93FA002Accident · 4 fatalField investigationFinal reportBeech N35 · Burlington, WAThe failure of screws on the propeller hub during takeoff, the improper inflight decision by the pilot to return for landing, and the steep, excessive bank angle which resulted in a stall/spin and loss of control.NTSB FTW93FA002Accident · 1 fatalField investigationFinal reportClatanoff Rotorway Exec · Wimberley, TXThe delamination of the skin on a main rotor blade.NTSB BFO92LA154Accident · No injuriesLimited investigationFinal reportCessna 305A · Waynesville, OHThe chaffing of a landing gear brake line which caused the loss of hydraulic fluid and subsequent loss of braking action.NTSB LAX92LA400Accident · 1 fatalLimited investigationFinal reportSchleicher ASW-20 · Middletown, CAThe pilot's failure to connect the elevator control during assembly and failure to perform an adequate aircraft preflight check. Contributing to the accident was the pilots distraction by performing other tasks during the assembly procedure.NTSB BFO92FA144Accident · 2 fatalField investigationFinal reportHughes 269C · East Bernstadt, KYInadequate maintenance inspection involving failure to detect wear of the clutch spring assembly, resulting in the uncoupling of engine power to the main transmission.NTSB BFO92LA143Accident · Serious injuriesLimited investigationFinal reportGrumman AA-1A · Bedford, MAInadequate maintenance inspection which failed to reveal a deteriorated rudder cable which subsequently failed and caused loss of directional control.NTSB MIA92LA189Accident · No injuriesLimited investigationFinal reportCessna 210L · Orlando, FLUndetected chaffing and grounding of a wire to the nose landing gear squat switch which resulted in the landing gear being signalled at all times for gear up when electrical power was applied to the system. Contributing to the accident was the overheating of…NTSB MIA92LA188Accident · No injuriesLimited investigationFinal reportCessna 210L · Orlando, FLFailure of the right main landing gear actuator due to overstress for undetermined reasons which resulted in loss of all landing gear system hydraulic fluid which in turn resulted in the pilot being unable to extend and lock the landing gear.NTSB FTW92LA230Accident · No injuriesLimited investigationFinal reportCessna 172P · Fulshear, TXThe pilot's failure to attain the proper point of touchdown. Factors were the popped circuit breaker, the inoperative alternator, and the darkness of the night.NTSB BFO92IA145Incident · No injuriesIncident investigationFinal reportLockheed L1011-385 · Boston, MAInadequate lubrication which caused stress corrosion cracking and the separation of the right wing number two flap vane.NTSB FTW92GA227Accident · No injuriesFinal reportCessna T210L · Spring, TXThe pilot under instruction failure to follow the landing checklist and the instructor pilot's inadequate supervision. A factor was the overheated landing gear motor.NTSB FTW92LA225Accident · Minor injuriesLimited investigationFinal reportCessna 172I · Victoria, TXBlocked engine assembly breather tube and the pilot's continued operation with known maintenance discrepancies. Factors were oil on windsheild and reduced visibility due to oil on the windscreen..NTSB MIA92LA181Accident · Minor injuriesLimited investigationFinal reportAero Commander 100 · Panacea, FLFailure of the nose landing gear push/pull rod end bearing for undetermined reasons.NTSB CHI92DEC04Accident · Serious injuriesFinal reportTennessee Engineering & Manf Z-MAX · Manchester, MIAn inadequate design of the rudder control system by the pilot/builder of the airplane, a pullup performed by the pilot, and a total failure of the rudder flight control system.NTSB ANC92FA164Accident · 3 fatalField investigationFinal reportMcdonnell Douglas 369D · Eagle, AKAn inflight fatigue failure and separation of a main rotor blade, inadequate operator maintenance and inspection, and material defect.NTSB MIA92LA179Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Satartia, MSFailure of the brake system due to installation of a bogus part by an unknown person. Directional control by the pilot in command was not possible.NTSB ANC92FA159Accident · Serious injuriesField investigationFinal reportHughes 369D · Nunavaugaluk Lk, AKThe separation of the tail rotor abrasion strip and the subsequent total loss of the tail rotor. Factors contributing to the accident were: insufficient manufacturer's maintenance design changes, inadequate aircraft equipment design by the manufacturer and…NTSB CHI92FA267Accident · 1 fatalField investigationFinal reportPiper PA-61-601P · Aurora, INExceeding the design stress limits of the airplane by the pilot in command.NTSB ANC92LA175Accident · No injuriesLimited investigationFinal reportAeronca 15AC · Ptarmigan Pass, AKThe partial failure of the normal brake system, the misjudging of the proper touchdown point and the attempted go around. Factor was the rough and uneven landing area.NTSB MIA92LA177Accident · No injuriesLimited investigationFinal reportCessna A150K · Palatka, FLThe pilot in command's failure to maintain airspeed while performing a go around resulting in the aircraft stalling and descending uncontrolled to the ground.NTSB BFO92LA129Accident · Serious injuriesLimited investigationFinal reportPiper PA-30K · Schaghticoke, NYThe loss of total engine power due to fuel starvation. Contributing to the accident was the loss of total electrical power.