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.

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.Sep 25, 1992 · N9609F · DestroyedNTSB 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.Sep 25, 1992 · N58315 · Substantial damageNTSB 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.Sep 24, 1992 · N9811L · DestroyedNTSB FTW92DPG17Accident · No injuriesFinal reportCessna A188B · Holly Grove, ARThe pilot failed to maintain object clearance.Sep 24, 1992 · N4804Q · Substantial damageNTSB DEN92LA095Accident · Serious injuriesLimited investigationFinal reportCameron V-77 · Littleton, COUndetermined.Sep 24, 1992 · N7403U · No damageNTSB 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.Sep 24, 1992 · N602LJ · Substantial damageNTSB 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.Sep 24, 1992 · N6445L · Substantial damageNTSB LAX92IA397Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC 10-10 · San Francisco, CAA fractured compressor assembly.Sep 23, 1992 · N1845U · Minor damageNTSB 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.Sep 23, 1992 · N1943H · Substantial damageNTSB 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.Sep 23, 1992 · N2484Y · Substantial damageNTSB CHI92FA290Accident · No injuriesField investigationFinal reportBeech B55 · Joliet, ILThe pilot's inadvertent wheels up landing.Sep 23, 1992 · N557T · Substantial damageNTSB 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…Sep 23, 1992 · N43313 · DestroyedNTSB 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.Sep 23, 1992 · N85502 · Substantial damageNTSB 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.Sep 22, 1992 · N7337B · Substantial damageNTSB 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.Sep 22, 1992 · N121PL · DestroyedNTSB FTW92DPG16Accident · No injuriesFinal reportGulfstream G-164B · Holly Grove, ARLoss of engine power undetermined. Factor was unsuitable terrain.Sep 22, 1992 · N8075K · Substantial damageNTSB 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.Sep 22, 1992 · N1654G · Substantial damageNTSB 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.Sep 21, 1992 · N144PT · Substantial damageNTSB 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.Sep 21, 1992 · CFSJA · DestroyedNTSB 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…Sep 21, 1992 · N2013S · Substantial damageNTSB 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.Sep 21, 1992 · N777BK · Substantial damageNTSB 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.Sep 21, 1992 · N6DB · Substantial damageNTSB LAX92LA396Accident · Minor injuriesLimited investigationFinal reportBell 47-G4A · Volcano, HIThe pilot's improper use of the collective control after inadvertently entering a power settling condition.Sep 21, 1992 · N73279 · Substantial damageNTSB 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.Sep 21, 1992 · N97489 · Substantial damageNTSB 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.Sep 21, 1992 · N2141T · Substantial damageNTSB CHI92LA283Accident · Minor injuriesLimited investigationFinal reportCessna 182B · Baldwin, WISpatial disorientation as the pilot attempted visual flight procedures in instrument meteorological conditions.Sep 21, 1992 · N90BF · DestroyedNTSB 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…Sep 21, 1992 · N99693 · DestroyedNTSB 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.Sep 20, 1992 · N39039 · Substantial damageNTSB MIA92WA192Accident · No injuriesForeign investigationPiper PA-23-250 · Mores Island, BahamasSep 20, 1992 · N102ZZ · Substantial damageNTSB 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.Sep 20, 1992 · N747P · Substantial damageNTSB 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.Sep 20, 1992 · N711YM · Substantial damageNTSB 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.Sep 20, 1992 · N4AN · DestroyedNTSB 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.Sep 20, 1992 · N3288D · Substantial damageNTSB 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.Sep 20, 1992 · N34893 · Substantial damageNTSB 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.Sep 20, 1992 · N9234U · Substantial damageNTSB 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.Sep 20, 1992 · N4591P · DestroyedNTSB 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.Sep 20, 1992 · N786DL · Minor damageNTSB 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.Sep 20, 1992 · N46076 · DestroyedNTSB 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.Sep 20, 1992 · N840Z · Substantial damageNTSB 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.Sep 19, 1992 · N12089 · Substantial damageNTSB 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.Sep 19, 1992 · N7894P · Substantial damageNTSB MIA92WA193Incident · No injuriesForeign investigationBoeing 747-287 · Rio De Janeiro, BrazilSep 19, 1992 · LVMLP · Minor damageNTSB 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.Sep 19, 1992 · N9578H · DestroyedNTSB 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.Sep 19, 1992 · N732JF · Substantial damageNTSB 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…Sep 19, 1992 · N102SR · DestroyedNTSB 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.Sep 19, 1992 · N513F · Substantial damageNTSB 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.Sep 18, 1992 · N9662S · DestroyedNTSB 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.Sep 18, 1992 · N62036 · DestroyedNTSB 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.Sep 18, 1992 · N704B · DestroyedNTSB 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.Sep 18, 1992 · N2183A · Substantial damage