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 CHI94LA284Accident · Serious injuriesLimited investigationFinal reportHead Balloons AX7-77 · West Chicago, ILthe pilot's failure to maintain proper descent rate.Jun 25, 1994 · N21WR · No damageNTSB CHI94LA210Accident · No injuriesLimited investigationFinal reportTaylorcraft BL-65 · Peshtigo, WIthe pilot's failure to maintain airspeed during the takeoff which resulted in an inadvertent stall. A factor related to the accident was the tall grass on the airstrip.Jun 25, 1994 · N26690 · Substantial damageNTSB CHI94FA209Accident · Serious injuriesField investigationFinal reportCameron CAN-56 · West Chicago, ILthe pilots failure to maintain vertical clearance above powerlines which bordered the field in which he intended to land. A factor associated with the accident were the powerlines.Jun 25, 1994 · N20367 · DestroyedNTSB CHI94DCJ02Accident · Minor injuriesFinal reportMueller Q2 · Utica, NEThe failure of the carburetor float valve. A related factor is the high vegetation at the landing site.Jun 25, 1994 · N524WM · DestroyedNTSB ATL94LA126Accident · Serious injuriesLimited investigationFinal reportGreen Starduster TOO · Chattanooga, TNThe pilot's failure to maintain aircraft control, resulting in an inadvertent stall, and collision with terrain.Jun 25, 1994 · N11TG · Substantial damageNTSB ATL94LA125Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Kitty Hawk, NCThe pilot's improper compensation for the wind conditions, his improper recovery from a bounced landing, and the inadvertent stall. Factors were the wind conditions and the trees that bounded the runway.Jun 25, 1994 · N54920 · Substantial damageNTSB ANC94LA071Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Fairbanks, AKThe pilot's inadequate compensation for the wind conditions during the landing. The gusty wind condition was a factor.Jun 25, 1994 · N9869D · Substantial damageNTSB SEA94LA157Accident · Minor injuriesLimited investigationFinal reportCessna T210L · Chiloquin, ORFuel exhaustion due to a false indication on the fuel quantity sensor.Jun 24, 1994 · N59187 · Substantial damageNTSB MIA94LA166Accident · No injuriesLimited investigationFinal reportBritish Aerospace BAE 3201 · Orlando, FLInadvertent deactivation of the parking brake by the pilot-in-command. Contributing to the accident was the worn condition of the parking brake assembly.Jun 24, 1994 · N495UE · Substantial damageNTSB MIA94FA167Accident · 2 fatalField investigationFinal reportPiper PA-31-325 · Lantana, FLThe pilot's impairment of judgment and performance due to drugs, his failure to abort the takeoff after experiencing reduced takeoff performance, and his failure to maintain minimum control speed. Factors in the accident were: a partial loss of engine power…Jun 24, 1994 · N27872 · Substantial damageNTSB LAX94LA264Accident · No injuriesLimited investigationFinal reportCessna 210A · Mesquite, NVExhaustion of the brake system hydraulic fluid due to an inadequate annual inspection.Jun 24, 1994 · N6659X · Substantial damageNTSB FTW94LA214Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Coy, ARThe separation of the landing gear due to failure of the landing gear axle bolts.Jun 24, 1994 · N5321 · Substantial damageNTSB CHI94DCJ01Accident · Serious injuriesFinal reportMustari Dragonfly Mark II · Scottsbluff, NEthe private pilot's inadequate preflight planning/preparation. A related factor is the high density altitude.Jun 24, 1994 · N3147B · DestroyedNTSB BFO94LA114Accident · No injuriesLimited investigationFinal reportCessna 150 · Swanton, VTThe student pilot's failure to maintain directional control.Jun 24, 1994 · N714CX · Substantial damageNTSB NYC94LA124Accident · No injuriesLimited investigationFinal reportCessna 140 · Mount Vernon, OHThe pilot's inadequate handling which resulted in the airplane nosing over during the takeoff roll.Jun 23, 1994 · N3627V · DestroyedNTSB LAX94LA263Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Cloverdale, CALoss of engine power for an unknown reason.Jun 23, 1994 · N8549C · Substantial damageNTSB CHI94LA191Accident · 1 fatalLimited investigationFinal reportHiller HU-12E · Watertown, SDthe pilot's failure to maintain a visual lookout. A factor associated with the accident was the powerlines.Jun 23, 1994 · N330CW · DestroyedNTSB BFO94LA113Accident · Minor injuriesLimited investigationFinal reportPiper PA-32R-300 · Seven Springs, PAThe pilot's failure to attain adequate airspeed and his premature liftoff which resulted in a stall mush and collision with trees.Jun 23, 1994 · N40051 · Substantial damageNTSB ANC94FA070Accident · 7 fatalField investigationFinal reportde Havilland DHC-3 · Juneau, AKVFR flight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain altitude (clearance) above the surface of the river. Factors related to the accident were: the adverse weather conditions, and the surface condition of the…Jun 23, 1994 · N13GA · Substantial damageNTSB SEA94LA158Accident · No injuriesLimited investigationFinal reportCessna A188 · Cut Bank, MTThe pilot's failure to adequately compensate for wind conditions. The crosswind and the ditch were factors.Jun 22, 1994 · N9879V · Substantial damageNTSB NYC94LA102Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · New Philadelphi, OHThe pilot's inadequate decision and his delay in aborting the takeoff, which resulted in an overrun of the runway and collision with obstaclesJun 22, 1994 · N5543F · Substantial damageNTSB MIA94LA165Accident · Serious injuriesLimited investigationFinal reportHughes 369HS · Sarasota, FLAltitude misjudged by the pilot.Jun 22, 1994 · N520TC · Substantial damageNTSB MIA94LA164Accident · No injuriesLimited investigationFinal reportCessna 152 · Opa-Locka, FLThe pilot's improper handling of the aircraft during the landing. Contributing to the accident was the lack of total experience by the pilot-in-command.Jun 22, 1994 · N936JH · Substantial damageNTSB FTW94LA210Accident · No injuriesLimited investigationFinal reportHiller UH-12L4 · West Helena, ARA total loss of power due to a leak in the main fuel line which occurred as a result of an electrical short which burned a hole in the fuel line. Factors were a failure by the pilot to perform recommended maintenance and the lack of suitable terrain for a…Jun 22, 1994 · N90453 · DestroyedNTSB FTW94LA209Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Parkin, ARTotal power loss for undetermined reasons. A factor was unsuitable terrain for a forced landing.Jun 22, 1994 · N6535 · Substantial damageNTSB CHI94DTK02Accident · No injuriesFinal reportAyres S2R · Letcher, SDthe loss of engine power due to the failure of the engine driven fuel pump and shaft.Jun 22, 1994 · N3102E · DestroyedNTSB BFO94LA110Accident · Minor injuriesLimited investigationFinal reportRyan Navion B · Amherst, OHInadequate maintenance by an unqualified person which resulted in the loss of engine ignition due to worn ignition wires.Jun 22, 1994 · N5360K · Substantial damageNTSB SEA94LA155Accident · No injuriesLimited investigationFinal reportCessna 150L · Hubbard, ORDelayed in flight planning/decision.Jun 21, 1994 · N19297 · Substantial damageNTSB SEA94LA153Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Hillsboro, ORThe improper servicing of the skid shock struts.Jun 21, 1994 · N7506A · Substantial damageNTSB SEA94FA154Accident · 1 fatalField investigationFinal reportCessna 172 · Port Angeles, WALack of oil and connecting rod failure. A factor to the accident was rough/uneven terrain.Jun 21, 1994 · N8025B · DestroyedNTSB MIA94LA163Accident · Minor injuriesLimited investigationFinal reportCessna 210N · Bartow, FLThe pilot-in-command's failure to maintain a visual lookout during a forced landing resulting in an in-flight collision with wires. Contributing to the accident was the total loss of engine power due to the pilot's improper fuel consumption calculations, and…Jun 21, 1994 · N9992Y · Substantial damageNTSB FTW94T#A02Accident · No injuriesClass 3Final reportHughes OH-6A · Valentine, TXJun 21, 1994 · N6636G · DestroyedNTSB FTW94FA206Accident · 1 fatalField investigationFinal reportLuscombe 8A · Decatur, TXThe pilot's loss of control while maneuvering. Factors were the pilot's maneuvering at an low altitude and his lack of recent experience in make and model.Jun 21, 1994 · N71347 · Substantial damageNTSB FTW94FA203Accident · Serious injuriesField investigationFinal reportCessna 175B · Sonora, TXThe pilot's failure to maintain obstacle clearance.Jun 21, 1994 · N8103T · Substantial damageNTSB CHI94LA208Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Warren, MNthe pilot's improper use of the parking brake.Jun 21, 1994 · N6808M · Substantial damageNTSB CHI94LA207Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · Lake Station, INthe pilot-in-command's inattention to the fuel supply. A factor was rough and uneven terrain.Jun 21, 1994 · N4572X · Substantial damageNTSB ATL94LA146Accident · No injuriesLimited investigationFinal reportSwearingen SA-26AT · Greenville, SCThe pilot's failure to properly flare the aircraft during landing, resulting in a hard landing.Jun 21, 1994 · N802DJ · Substantial damageNTSB NYC94LA101Accident · Minor injuriesLimited investigationFinal reportJones Thorp T-18 · East Quogue, NYInadequate maintenance which resulted in oil-fouled spark plugs and the loss of engine power.Jun 20, 1994 · N64628 · Substantial damageNTSB LAX94LA261Accident · 2 fatalLimited investigationFinal reportCessna 152 · Half Moon Bay, CAThe pilot's loss of aircraft control due to spatial disorientation.Jun 20, 1994 · N761GZ · DestroyedNTSB LAX94LA260Accident · No injuriesLimited investigationFinal reportMooney M20J · Big Bear, CAa loss of engine power from a malfunctioning magneto due to a loose oil seal in an overhauled magneto.Jun 20, 1994 · N201NK · Substantial damageNTSB FTW94LA205Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Brinkley, ARA supercharger impeller bearing failure. A factor was the lack of suitable terrain for the forced landing.Jun 20, 1994 · N112JM · Substantial damageNTSB FTW94GA204Accident · Minor injuriesFinal reportHughes 269C · London, TXThe partial power loss due to a sticking valve. Factors were the remaining worn lobes on the camshaft and the lack of suitable terrain onto which a successful forced landing could be executed.Jun 20, 1994 · N7404F · DestroyedNTSB SEA94LA151Accident · Minor injuriesLimited investigationFinal reportCessna 182Q · Indian Valley, IDConnecting rod bolt fatigue and no suitable terrain for the forced landing.Jun 19, 1994 · N735QB · Substantial damageNTSB MIA94LA162Accident · 1 fatalLimited investigationFinal reportStolte Deuce · Prentiss, MSFailure of the pilot to maintain proper altitude while performing an aerobatic maneuver and recovering from a spin. Factors related to the accident were: the pilot's failure to follow procedures/directives, lack of formal training in aerobatic flight, and…Jun 19, 1994 · N10RS · DestroyedNTSB MIA94LA161Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Atlantic Ocean (Atlantic Ocean)The pilot-in-command's failure to maintain a visual outlook and a safe altitude while making a low pass over a boat, resulting in an in-flight collision with the boat mast.Jun 19, 1994 · N5333Y · Substantial damageNTSB LAX94LA262Accident · Minor injuriesLimited investigationFinal reportPayne Foster Glasair · Hesperia, CAthe pilot's loss of directional control during an attempted landing and subsequent go-around. Factors were the high-density altitude, inappropriate fuel leaning procedures, and the gust of wind.Jun 19, 1994 · N250CH · Substantial damageNTSB IAD94LA109Accident · No injuriesLimited investigationFinal reportbourque experimental Kitfox · Chester, CTThe fracture of the tailwheel assembly for undetermined reasons during the takeoff roll, and the subsequent loss of directional control and collision with a hangar.Jun 19, 1994 · N528AB · Substantial damageNTSB FTW94LA202Accident · Serious injuriesLimited investigationFinal reportRiley, Donald Rutan Varieze · Fort Lupton, COBlockage of the oil scavenge pump by foreign material which was introduced into the engine during maintenance. A factor was the lack of suitable terrain for the forced landing.Jun 19, 1994 · N111DR · DestroyedNTSB FTW94FA208Accident · 1 fatalField investigationFinal reportPiper PA-28R-201T · Southard, OKThe pilot's continued flight into known adverse weather resulting in the design limits of the airplane being exceeded. Factors were the thunderstorms and the pilot's disregard for the forecasted adverse weather.Jun 19, 1994 · N9766K · DestroyedNTSB CHI94LA203Accident · 1 fatalLimited investigationFinal reportPiper PA-18 · Terre Haute, INthe pilot-in-command's inadvertant stall of the airplane. A factor associated with the accident was the elevator trim position.Jun 19, 1994 · N81TW · Destroyed