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 ATL95LA053Accident · No injuriesLimited investigationFinal reportSchweizer 269B · Addison, ALThe pilot's improper use of the throttle control during a descent which resulted in a hard landing.Feb 18, 1995 · N11XC · Substantial damageNTSB LAX95WA165Accident · 2 fatalForeign investigationBeech BE-55 · Laurieton, AustraliaFeb 17, 1995 · N9124S · DestroyedNTSB FTW95LA120Accident · No injuriesLimited investigationFinal reportCessna T210M · Montrose, COThe bent landing gear emergency extension assembly and the accumulation of airframe ice which interfered with landing gear activation. A factor was the alternator failure for unknown reasons.Feb 17, 1995 · N6094B · Substantial damageNTSB FTW95LA117Accident · No injuriesLimited investigationFinal reportCessna 172RG · Plano, TXThe disengagement of the crankshaft gear due to the loosening of the gear retaining bolt and the subsequent fracture of the gear alignment dowel. A factor was the lack of suitable terrain available for the forced landing.Feb 17, 1995 · N5096U · Substantial damageNTSB DCA95MA020Accident · 3 fatalClass 1 · MajorFinal reportDouglas DC-8-63 · Kansas City, MO(1) The loss of directional control by the pilot in command during the takeoff roll, and his decision to continue the takeoff and initiate a rotation below the computed rotation airspeed, resulting in a premature liftoff, further loss of control and collision…Feb 17, 1995 · N782AL · DestroyedNTSB LAX95LA115Accident · No injuriesLimited investigationFinal reportSkov-Papworth Q2 · Hollister, CAthe pilot's failure to maintain directional control of the aircraft during the takeoff ground roll. The pilot's lack of recent experience is a factor in the accident.Feb 16, 1995 · N2103 · Substantial damageNTSB LAX95LA110Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Corona, CAthe pilot's failure to maintain runway alignment after aborting a takeoff and improper use of the brakes during the abort.Feb 16, 1995 · N9512H · Substantial damageNTSB CHI95LA086Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Minneapolis, MNan inadequate windshield deicing system for the inflight icing encountered, airframe icing, and the pilot's inability to maintain a proper descent rate. Factors associated with this accident were an inadequate weather forecast and icing conditions.Feb 16, 1995 · N62711 · Substantial damageNTSB NYC95LA055Accident · No injuriesLimited investigationFinal reportBeech C23 · Rochester, NHThe pilot's inadequate inflight planning/decision and inadvertently turning the ignition switch to the off position. A factor was the ignition switch stuck in the off position.Feb 15, 1995 · N812Y · Substantial damageNTSB NYC95FA056Accident · 2 fatalField investigationFinal reportPiper PA-46-310P · Chippewa Falls, WIThe pilot's improper decision to depart into known adverse weather conditions, and the subsequent encounter with freezing drizzle, resulting in an inadvertent stall and collision with the terrain during an approach to land. Also causal to the accident was the…Feb 15, 1995 · N9YP · DestroyedNTSB MIA95LA074Accident · No injuriesLimited investigationFinal reportCessna 525 · Wauchula, FLImproper in-flight planning and decision by the pilot-in-command resulting in excessive airspeed on approach. A contributing factor was the improper decision of the pilot-in-command not to execute a go-around while adequate runway remained.Feb 15, 1995 · N63HB · Substantial damageNTSB LAX95LA109Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Arvin, CAThe seizure of the transmission due to lack of lubrication from a plugged oil supply line.Feb 15, 1995 · N5335V · Substantial damageNTSB CHI95LA089Accident · No injuriesLimited investigationFinal reportCessna T310R · Grand Island, NEthe pilot's failure to deploy the deicing boots during the approach and the failure to maintain aircraft control during the landing. A factor related to the accident was the existing icing conditions.Feb 15, 1995 · N4092C · Substantial damageNTSB NYC95LA054Accident · No injuriesLimited investigationFinal reportCessna 152 · Mount Snow, VTThe pilot's inadequate compensation for wind which resulted in the airplane drifting into a snow bank and nosing over.Feb 14, 1995 · N757SG · Substantial damageNTSB NYC95LA053Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Colts Neck, NJThe loss of engine power for undetermined reasons. A factor relating to this accident was the unsuitable terrain.Feb 14, 1995 · N89712 · Substantial damageNTSB FTW95LA115Accident · Minor injuriesLimited investigationFinal reportCessna 414 · Mcgregor, TXThe pilot's delayed initiation of the missed approach until well below the minimum descent altitude and beyond the published missed approach point. Factors were the dark night and the low ceiling and visibility.Feb 14, 1995 · N4643G · DestroyedNTSB FTW95FA116Accident · 5 fatalField investigationFinal reportBell 206L-4 · East CameronInadvertent flight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain control of the helicopter after becoming spatially disoriented. Factors related to the accident were: the adverse weather conditions, and the pilot's…Feb 14, 1995 · N172AL · DestroyedNTSB SEA95LA051Accident · Serious injuriesLimited investigationFinal reportSikorsky S-58JT · Marblemount, WAFatigue failure of the main rotor driveshaft.Feb 13, 1995 · N1099T · Substantial damageNTSB NYC95LA052Accident · No injuriesLimited investigationFinal reportCessna 210L · Dayton, OHThe pilot's inadequate compensation for wind and not attaining directional control which resulted in the airplane impacting a snow bank and nosing over.Feb 13, 1995 · N1RB · Substantial damageNTSB MIA95LA075Accident · Serious injuriesLimited investigationFinal reportCessna 172K · Wrightsville, GAThe pilot-in-command's failure to maintain adequate airspeed while maneuvering in a turn. The low altitude at the time of the stall was a factor.Feb 13, 1995 · N79157 · Substantial damageNTSB DCA95MA019Accident · 8 fatalMajor investigationFinal reportPiper PA-31-350 · Tusayan, AZa loss of power on one engine for an undetermined reason(s), and the pilot's improper decision to return to the departure airport for landing which neccessitated maneuvering over increasingly higher terrain. Factors in the accident were: the high gusting…Feb 13, 1995 · N27245 · DestroyedNTSB ATL95LA051Accident · No injuriesLimited investigationFinal reportTaylorcraft F19 · Tullahoma, TNA lack of lubricant to the starter/roller clutch, seizure of the starter, and failure of the four crankshaft gear capscrews (bolts), which resulted in disengagement of the crankshaft (accessory) gear and subsequent loss of engine power.Feb 13, 1995 · N20001 · Substantial damageNTSB LAX95LA108Accident · 3 fatalLimited investigationFinal reportCessna 182Q · San Francisco, CAan inflight collision with water for undetermined reasons.Feb 12, 1995 · N4875N · DestroyedNTSB LAX95LA107Accident · Serious injuriesLimited investigationFinal reportVarga 2150A · Yuma, AZfuel exhaustion due to the pilot's inadequate preflight inspection and his failure to refuel the aircraft.Feb 12, 1995 · N56180 · DestroyedNTSB LAX95FA104Accident · 1 fatalField investigationFinal reportBellanca 7GCBC · Modesto, CAThe pilot lost control of the airplane for an unknown reason.Feb 12, 1995 · N53972 · DestroyedNTSB FTW95FA114Accident · 2 fatalField investigationFinal reportRockwell 690A · Guthrie, OKThe pilot's failure to maintain adequate airspeed due to airframe ice, which resulted in a loss of control. Factors contributing to the accident were the pilot's continued flight into adverse weather, his failure to obtain weather information either before or…Feb 12, 1995 · N69TM · DestroyedNTSB SEA95LA050Accident · No injuriesLimited investigationFinal reportBeech S-35 · Wolf Point, MTThe loss of power due to lost oil pressure and a failed connecting rod. Factors include fence posts and dusk lighting conditions which limited visibility.Feb 11, 1995 · N8828M · Substantial damageNTSB SEA95LA049Accident · No injuriesLimited investigationFinal reportCessna 180 · Camas, WAInadequate remedial action by the flight instructor after the student lost directional control.Feb 11, 1995 · N626RP · Substantial damageNTSB MIA95LA076Accident · Minor injuriesLimited investigationFinal reportPiper PA-30 · Miami, FLThe failure of the truck driver to follow airport operations procedures and signs.Feb 11, 1995 · N8778Y · Substantial damageNTSB LAX95LA106Accident · No injuriesLimited investigationFinal reportBurkhart Grob Twin Astir · Fort Huachuca, AZImproper in-flight planning/decision by the pilot, which resulted in his failure to remain clear of tree(s) during an off-airport landing. Factors related to the accident were: lack of thermal lift, and high obstructions in the off-airport landing area.Feb 11, 1995 · N333BH · Substantial damageNTSB LAX95FA105Accident · 2 fatalField investigationFinal reportPiper PA-32R-301T · Ceres, CAthe pilot inadvertently becoming lost/disoriented during a missed approach, his failure to follow the proper missed approach procedure, and his failure to maintain control of the aircraft due to spatial disorientation.Feb 11, 1995 · N560LM · DestroyedNTSB LAX95FA103Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Jamestown, CAthe pilot's intentional flight into IMC conditions and subsequent in-flight loss of control due to spatial disorientation.Feb 11, 1995 · CFCNW · DestroyedNTSB ATL95FA050Accident · 1 fatalField investigationFinal reportBeech B60 · Gatlinburg, TNThe pilot's continued visual flight into instrument weather conditions that resulted in a collision with rising terrain.Feb 11, 1995 · N6749S · DestroyedNTSB ATL95FA049Accident · 1 fatalField investigationFinal reportCessna 150J · Piedmont, SCThe pilot's inappropriate 'buzzing' that resulted in exceeding the airplane's design stress limits, the failure of the windshield, and the pilot's subsequent loss of control and impact with the ground.Feb 11, 1995 · N607BB · DestroyedNTSB SEA95LA047Accident · No injuriesLimited investigationFinal reportCessna 120 · Scappoose, ORThe pilot's improper recovery from a bounced landing and inadvertent use of the brakes.Feb 10, 1995 · N77480 · Substantial damageNTSB SEA95FA048Accident · 2 fatalField investigationFinal reportPiper PA-601P · Tremonton, UTThe pilot's attempt to conduct visual flight into instrument meteorological conditions, and his failure to maintain altitude/clearance with the mountainous terrain. Factors were the clouds, and the dark night.Feb 10, 1995 · N57NW · DestroyedNTSB FTW95FA112Accident · 5 fatalField investigationFinal reportPiper PA-32R-300 · Conroe, TXThe pilot's failure to follow published IFR procedures. Factors were the weather conditions, the dark night, and the pilot's failure to activate the approach lighting system.Feb 10, 1995 · N5373F · DestroyedNTSB LAX95LA101Accident · 1 fatalLimited investigationFinal reportCessna 172G · Pope Valley, CAthe pilot's poor judgment to buzz the lake and his inadequate visual lookout.Feb 9, 1995 · N4345L · DestroyedNTSB FTW95FA111Accident · 1 fatalField investigationFinal reportCessna 177RG · Larkspur, COThe pilot's decision to continue VFR flight into instrument meteorological conditions after being advised that VFR flight was not recommended. The weather and dark night were factors in the accident.Feb 9, 1995 · N33MR · DestroyedNTSB ATL95LA048Accident · Minor injuriesLimited investigationFinal reportCessna T210G · Covington, TNThe pilot's inadequate preflight inspection of the aircraft, in that he did not adequately drain water from the fuel system, resulting in water ingestion into the engine.Feb 9, 1995 · N6854R · Substantial damageNTSB MIA95LA073Accident · Serious injuriesLimited investigationFinal reportRoy Long EZ · Columbus, MSThe pilot's inadequate preflight inspection of the fuel system. This resulted in a total loss of engine power in cruise flight, due to fuel contamination, forced landing, and subsequent in- flight collision with trees and terrain.Feb 8, 1995 · N723HK · DestroyedNTSB FTW95LA113Accident · 1 fatalLimited investigationFinal reportPiper PA-32-300 · Howard, COThe pilot's flight into known adverse weather over mountainous terrain at an inadequate altitude to recover from turbulence/downdraft. Factors related to the accident were: inadequate preflight planning/preparation by the pilot, his inadequate weather…Feb 8, 1995 · N41345 · DestroyedNTSB NYC95LA051Accident · No injuriesLimited investigationFinal reportCessna 152 · Belmont, NHThe pilot's inadequate preflight of the airplane that failed to detect the ice clogged breather which resulted in the loss of oil and a subsequent emergency landing.Feb 7, 1995 · N6182P · Substantial damageNTSB MIA95LA071Accident · No injuriesLimited investigationFinal reportCessna 152 · Venice, FLThe pilot's failure to perform a go-around and failure to apply power to recover from the bounced landing.Feb 7, 1995 · N47183 · Substantial damageNTSB MIA95FA072Accident · Serious injuriesField investigationFinal reportCessna 152 · Mobile, ALThe pilot's improper planning/decision, which resulted in fuel exhaustion before reaching the airport, and his failure to maintain adequate airspeed while maneuvering for a forced landing, which resulted in an inadvertent stall and collision with the terrain.Feb 7, 1995 · N757XX · Substantial damageNTSB LAX95LA100Accident · No injuriesLimited investigationFinal reportBell 47G-3B · China Lake, CAthe pilot's misjudgement of the clearance between the main rotor and a tree while maneuvering at low altitude to herd animals.Feb 7, 1995 · N73240 · Substantial damageNTSB CHI95LA085Accident · No injuriesLimited investigationFinal reportPiper PA-23 · Benton Harbor, MIthe pilot's improper use of carburetor heat. Factors were carburetor icing conditions, snow, and blowing snow.Feb 7, 1995 · N2092P · Substantial damageNTSB SEA95LA045Accident · No injuriesLimited investigationFinal reportCessna 185 · Mccall, IDThe pilot's premature lift-off during the takeoff, leading to an aerodynamic stall. A factor contributing to the accident was the pilot's attempt to perform a formation takeoff.Feb 6, 1995 · N9CR · Substantial damageNTSB FTW95LA110Accident · No injuriesLimited investigationFinal reportCessna 172M · Boulder, COThe pilot's premature rotation.Feb 6, 1995 · N80893 · Substantial damageNTSB FTW95LA108Accident · No injuriesLimited investigationFinal reportCraighead Corben JR. ACE · Athens, TXThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for a forced landing.Feb 6, 1995 · N30CK · Substantial damage