NTSB investigations
180,658 investigations by the National Transportation Safety Board since 1962: 174,636 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 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 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 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 ANC92LA178Accident · Minor injuriesLimited investigationFinal reportHughes 369D · George Inlet, AKThe pilot's improper in flight planning and decision and his failure to maintain altitude during the turn to reverse direction. Contributing to the accident was the calm water.NTSB SEA92LA214Accident · No injuriesLimited investigationFinal reportCessna 320B · Lowell, IDRam induction air starvation of both engines and inability of the pilot in command to clear trees during the forced landing. Factors contributing to the accident were low ceilings and trees.NTSB FTW92DPG17Accident · No injuriesFinal reportCessna A188B · Holly Grove, ARThe pilot failed to maintain object clearance.NTSB DEN92LA095Accident · Serious injuriesLimited investigationFinal reportCameron V-77 · Littleton, COUndetermined.NTSB CHI92LA289Accident · No injuriesLimited investigationFinal reportLearjet LR-60 · Hutchinson, KSInadequate flight test methods by the manufacturer and the FAA which did not permit safe operating clearances.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 LAX92IA397Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC 10-10 · San Francisco, CAA fractured compressor assembly.NTSB CHI92LA288Accident · No injuriesLimited investigationFinal reportBoeing B75N1 · Belvidere, ILThe pilot's failure to maintain adequate clearance from obstacles during the aborted landing. Related factors are the failure to maintain directional control, and the pilot's lack of total experience in the type of operation.NTSB CHI92LA287Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Peoria, ILThe private pilot's misjudged touchdown. Related factors are the reduced visibility due to sunglare, ongoing runway construction, and the pilot's inattention to atc/communications/information.NTSB CHI92FA290Accident · No injuriesField investigationFinal reportBeech B55 · Joliet, ILThe pilot's inadvertent wheels up landing.NTSB ATL92FA185Accident · 3 fatalField investigationFinal reportPiper PA-28-151 · Samantha, ALThe pilot's inadequate preflight planning and preparation, his lack of expereince, which resulted in an encounter with instrument weather conditions during an attempted visual flight, and his subsequent spatial disorientation. Factors were the dark night…NTSB ANC92LA180Accident · No injuriesLimited investigationFinal reportChampion 7AC · Homer, AKThe pilot in commands inflight planning/decision in selecting unsuitable terrain. A factor relating to the accident was the ditch.NTSB SEA92LA212Accident · No injuriesLimited investigationFinal reportBeech E35 · Anacortes, WAThe pilot in command's failure to maintain directional control. A factor contributing to the accident was: the pilot in command's not extending the flaps for landing.NTSB MIA92LA190Accident · Minor injuriesLimited investigationFinal reportCessna 210L · St. Augustine, FLThe pilot-in-command's failure to conduct a preflight inspection of the fuel tanks prior to takeoff.NTSB FTW92DPG16Accident · No injuriesFinal reportGulfstream G-164B · Holly Grove, ARLoss of engine power undetermined. Factor was unsuitable terrain.NTSB ANC92LA183Accident · Minor injuriesLimited investigationFinal reportChampion 7GCBC · Fairbanks, AKThe pilot's preflight planning/preparation in accessing the available runway length and snow conditions. Factors relating to the accident were the snow bank and the pilot in command's lack of familiarity with skiplane operations.NTSB SEA92LA211Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Blakely Island, WAThe removal of the control gust lock was not performed. Factors to the accident were: inadequate preflight, the checklist was not used, and the control gust lock marking flag was gone due to previous damage.NTSB SEA92LA209Accident · 2 fatalLimited investigationFinal reportAnderson Vans RV-6 · Puyallup, WAThe failure of the pilot to configure the acft for landing (lowering of flaps) and maintain airspeed above stall during final approach for landing.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 MIA92LA187Accident · No injuriesLimited investigationFinal reportHelio HE29 · Lantana, FLThe total failure of the landing gear tail wheel lock on landing roll out, resulting in an on ground loss of control (ground loop) and collapse of the left main landing gear.NTSB LAX92LA396Accident · Minor injuriesLimited investigationFinal reportBell 47-G4A · Volcano, HIThe pilot's improper use of the collective control after inadvertently entering a power settling condition.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 FTW92LA229Accident · No injuriesLimited investigationFinal reportPiper PA-28-200R · Fort Worth, TXThe pilot's failure to maintain proper clearance with the hole. Factors were the lack of markings and the poor maintenance of the taxiway and runway.NTSB CHI92LA283Accident · Minor injuriesLimited investigationFinal reportCessna 182B · Baldwin, WISpatial disorientation as the pilot attempted visual flight procedures in instrument meteorological conditions.NTSB BFO92FA152Accident · 2 fatalField investigationFinal reportMooney M20K · Weston, WVTotal loss of engine power due to the inadequate torque of the no. 1 cylinder attach bolts and studs, fatique failure of the bolts/studs, and separation of the no. 1 cylinder. Factors related to the accident were: darkness and hilly terrain, which were…NTSB SEA92LA208Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Gates, ORThe excessive application of the brakes by the pilot in command. Factors contributing to the accident were the tailwind and the pilots visual (mis)perception of runway gradient.NTSB MIA92WA192Accident · No injuriesForeign investigationPiper PA-23-250 · Mores Island, BahamasNTSB MIA92LA186Accident · Minor injuriesLimited investigationFinal reportTaylor Prescott · Plant City, FLThe pilot in command's failure to maintain airspeed (vso) during a go around, resulting in a loss of control (stall), and subsequent on ground collision with a parked airplane.NTSB LAX92LA399Accident · No injuriesLimited investigationFinal reportPiper 601P · Bakersfield, CAThe pilot's selection of an inadequate altitude for an intentional low pass. Contributing to the accident was the dusk light conditions, and the pilots improper inflight planning and decision.NTSB LAX92LA395Accident · Minor injuriesLimited investigationFinal reportAbrams/Nuding Quickie Q2 · Minden, NVFuel starvation for undetermined reasons. A factor in the accident was the unsuitable nature of the terrain for the forced landing attempt.NTSB LAX92LA394Accident · No injuriesLimited investigationFinal reportCessna 180 · Avalon, CAThe pilot's improper landing flare which resulted in a hard landing and a collapse of the left main landing gear.NTSB CHI92LA285Accident · No injuriesLimited investigationFinal reportCessna 177B · Norcross, MNThe pilot's premature liftoff which resulted in inadequate airspeed for takeoff. Factors related to the accident were the crosswind conditions, the pilot's inadequate compensation for the crosswind, and the pilot's total lack of experience.NTSB CHI92LA284Accident · No injuriesLimited investigationFinal reportCessna 150M · Joplin, MOPoor preflight planning and preparation along with the pilot's failure to assure an adequate fuel supply to complete the flight. A factor related to the accident was the downdraft encountered.NTSB CHI92FA282Accident · 1 fatalField investigationFinal reportCessna 152 · Ottawa, ILPilot did not maintain a proper airspeed which led to an inadvertent stall/spin at a low altitude where the pilot could not perform a recovery.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 BFO92FA153Accident · 1 fatalField investigationFinal reportCessna 152 · Gloucester, VAThe pilot's failure to recover from an intentional stall, which resluted in inflight collision with the ground. Pilot inexperience is a contributing factor.NTSB ATL92LA183Accident · 1 fatalLimited investigationFinal reportCorben Baby ACE · Jacksonville, NCThe pilot's failure to maintain flying speed which resulted in a loss of control and an inadvertent stall and collision with the ground.NTSB SEA92LA213Accident · No injuriesLimited investigationFinal reportCessna 172M · Lloyd, MTThe pilot in command's failure to maintain directional control. A factor contributing to the accident was wind gusts.NTSB SEA92LA207Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Smoot, WYThe pilot in command's delayed go-around. Factors contributing to the accident were the pilot in command's selection of unsuitable terrain and trees.NTSB MIA92WA193Incident · No injuriesForeign investigationBoeing 747-287 · Rio De Janeiro, BrazilNTSB MIA92LA185Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Picayune, MSThe pilot in command's failure to maintain airspeed (vso) while conducting slow flight at a low altitude. This resulted in an in flight loss of control (stall) and subsequent in flight collision with trees.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 BFO92FA151Accident · 3 fatalField investigationFinal reportCessna R182 · Edgartown, MAThe pilots's lack of regard for the published decision height of the approach and his decision not to execute a missed approach. Factors contributing to the accident include the pilot's failure to attain the proper glidepath and descent rate during the…NTSB ANC92LA176Accident · No injuriesLimited investigationFinal reportDe Havilland DHC-2 · Chitina, AKPilot in command preflight decision/planning in attempting takeoff without prudent and sufficient preparation to assess wind direction. A factor relating to the accident was: the trees in the clearway at the airstrip end.NTSB SEA92LA210Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Arlington, WYThe pilot in command's failure to touch down at the proper landing point on the road. A factor contributing to the accident was high density altitude.NTSB SEA92LA206Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Leavenworth, WAThe premature lift off by the pilot. Factors relating to the accident were the soft, rough turf airstrip and the high obstructions at the end of the runway.NTSB LAX92LA393Accident · 1 fatalLimited investigationFinal reportSparks-Schreder HP-140V · Avenal, CAThe loss of pitch and yaw control due to the separation of the ruddervator control cable from its clevis fork due to improper installation.NTSB FTW92LA228Accident · No injuriesLimited investigationFinal reportFairchild SA-227-AC · San Antonio, TXThe landing capability of the airplane was exceeded. The lack of performance data was a factor in the accident.