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 ANC94LA006Accident · No injuriesLimited investigationFinal reportPiper PA-18-160 · Aniak, AKThe pilot-in-command's failure to compensate for the wind conditions. The gusty wind was a factor.Oct 6, 1993 · N8479Y · Substantial damageNTSB SEA94LA009Accident · No injuriesLimited investigationFinal reportCessna 150E · Sandy, ORFailure of the pilot to maintain proper runway alignment during the landing. The lack of adequate runway alignment marking was a related factor.Oct 5, 1993 · N3071J · Substantial damageNTSB SEA94LA008Accident · No injuriesLimited investigationFinal reportCessna 172RG · Corvallis, ORThe cfi's inadequate in-flight planning, and his inadvertent gear-up landing. Factors include the cfi's diverted attention.Oct 5, 1993 · N16ED · Substantial damageNTSB FTW94LA005Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180C · Albuquerque, NMThe pilot's failure to maintain adequate airspeed. The high density altitude was a factor.Oct 5, 1993 · N9317J · DestroyedNTSB CHI94LA006Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Frankfort, MIthe pilot's failure to perform refueling.Oct 5, 1993 · N6862Z · Substantial damageNTSB ATL94LA003Accident · No injuriesLimited investigationFinal reportCessna T188C · Rogersville, ALWas the pilot's inadequate pre-flight preparation which resulted in fuel exhaustion during take off.Oct 5, 1993 · N42402 · Substantial damageNTSB ATL94LA002Accident · No injuriesLimited investigationFinal reportHughes 269B · Linville, NCThe pilot's failure to maintain airspeed that would have avoided a loss of tail rotor effectiveness (lte), and his improper compensation for tailwind condition. A factor was the lack of information in the pilot's operating handbook regarding the conditions…Oct 5, 1993 · N9333F · Substantial damageNTSB ANC94LA012Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Haines, AKFatigue failure in a weld on the right main landing gear oleo strut tubing.Oct 5, 1993 · N5285J · Substantial damageNTSB ANC94LA003Accident · 1 fatalLimited investigationFinal reportAeronca 11AC · Kenney Lake, AKThe pilot's intentional VFR takeoff into instrument meteorological conditions which resulted in spatial disorientation and a loss of control. Factors in the accident were the weather and low light conditions.Oct 5, 1993 · N9230E · DestroyedNTSB SEA94LA006Accident · No injuriesLimited investigationFinal reportCessna 177A · La Sal, UTThe pilot in command's failure to abort the takeoff. Factors contributing to the accident were the high (10,000 foot) density altitude and the fence.Oct 4, 1993 · N30365 · Substantial damageNTSB SEA94LA005Accident · No injuriesLimited investigationFinal reportCessna T182RG · Casper, WYInadequate maintenance and inspection of the hydraulic line resulting in a loss of hydraulic pressure.Oct 4, 1993 · N999RG · Substantial damageNTSB NYC94LA002Accident · No injuriesLimited investigationFinal reportGrumman G-164-A · Madisonville, KYthe pilot's inadequate preflight preparation and his inadequate visual lookout in flight which resulted in the collision with wires.Oct 4, 1993 · N9909 · DestroyedNTSB NYC94LA001Accident · No injuriesLimited investigationFinal reportCessna 172M · Wellsville, NYThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall and inflight collision with the terrain.Oct 4, 1993 · N20286 · Substantial damageNTSB FTW94LA004Accident · Minor injuriesLimited investigationFinal reportRaven Rally RX7 · Albuquerque, NMPilot's failure to maintain aircraft control. A factor was the gusty winds.Oct 4, 1993 · N27953 · Substantial damageNTSB CHI94LA009Accident · No injuriesLimited investigationFinal reportLuscombe 8F · Benton, KSThe failure of the student pilot to maintain directional control and proper runway alignment during the landing roll. The proximity of the ditch to the runway was a related factor.Oct 4, 1993 · N801B · Substantial damageNTSB ATL94IA001Incident · No injuriesIncident investigationFinal reportBoeing 757-232 · Fort Lauderdale, FLFailure of the captain to use the proper rotation and lift-off speeds, which resulted in over rotation of the aircraft during takeoff and a subsequent tail scrape.Oct 4, 1993 · N638DL · Minor damageNTSB ANC94LA008Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Port Heiden, AKThe pilot-in-command's improper preflight planning/preparation. A factor was rising terrain.Oct 4, 1993 · N81648 · Substantial damageNTSB ANC94LA004Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Bear Creek, AKThe pilot's delayed go-around procedure. A factor in the accident was the improper use of carburetor heat during the go-around.Oct 4, 1993 · N2765A · Substantial damageNTSB ANC94LA002Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Pilot Point, AKThe Pilot's improper preflight procedures in that the frost removal was not adequately performed resulting in aerodynamic stall of flight surfaces on takeoff.Oct 4, 1993 · N82231 · DestroyedNTSB SEA94LA007Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BC12-D · Shoshoni, WYFuel exhaustion and the pilot in command's failure to refuel the aircraft.Oct 3, 1993 · N44492 · Substantial damageNTSB SEA94LA003Accident · Serious injuriesLimited investigationFinal reportCessna 180H · Denton, MTThe pilot in command's failure to maintain adequate clearance with terrain. Factors contributing to the accident were unfavorable winds and the pilot in command's inadquate compensation (premature crosswind turn) for the wind conditions.Oct 3, 1993 · N9002M · Substantial damageNTSB SEA94LA002Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Orting, WAThe pilot in command's failure to maintain aircraft control.Oct 3, 1993 · N7709H · Substantial damageNTSB SEA94FA004Accident · 1 fatalField investigationFinal reportCessna 182P · Heber City, UTThe pilot's improper inflight decisions and failure to maintain proper altitude. Factors include the box canyon.Oct 3, 1993 · N50TH · DestroyedNTSB NYC94LA005Accident · No injuriesLimited investigationFinal reportSwift S-1 · Blairstown, NJThe pilot's failure to maintain adequate airspeed, which resulted in an inadvertent stall. A factor is wind gust and the pilot's inexperience in type aircraft.Oct 3, 1993 · N818AW · Substantial damageNTSB MIA94FA001Accident · Serious injuriesField investigationFinal reportMcdonnell Douglas MD-83 · Miami, FLThe failure of the water heater relay and the overpressure relief valve to operate properly. In addition, the design of the relief valve was inadequate in that it allowed the o-ring to migrate from its normal position preventing the valve from opening.Oct 3, 1993 · 9YTHR · Substantial damageNTSB LAX94FA005Accident · 3 fatalField investigationFinal reportPiper PA-32-300 · Kernville, CAthe pilot's inadvertent flight into a box canyon and his failure to attain a safe altitude. A factor in the accident was the pilot's lack of familiarity with the geographic area.Oct 3, 1993 · N4018W · DestroyedNTSB LAX94FA004Accident · 4 fatalField investigationFinal reportCessna 177RG · Petaluma, CAVFR flight by the pilot(s) into instrument meteorological conditions (IMC), and failure to maintain a proper altitude and/or clearance from terrain, while approaching the destination airport. Factors related to the accident were: the low ceiling and terrain.Oct 3, 1993 · N45022 · DestroyedNTSB FTW94LA002Accident · No injuriesLimited investigationFinal reportMaule M-5-200C · Watkins, COThe pilot's loss of directional control resulting in the inadvertent ground loop. A factor was the instructor's failure to take remedial action on a timely manner.Oct 3, 1993 · N16CB · Substantial damageNTSB FTW94LA001Accident · Minor injuriesLimited investigationFinal reportCessna T188C · New Deal, TXFailure of the pilot to maintain ground clearance while avoiding a powerline. Failure of the pilot to see a second set of power lines prior to initiating the spraying run was also a cause.Oct 3, 1993 · N2031J · Substantial damageNTSB CHI94LA016Accident · No injuriesLimited investigationFinal reportCessna 150J · Grosse Ile, MIThe pilot misjudged altitude/clearance during the banner pickup, which resulted in the tow rope snagging the landing gear, and failed to maintain adequate airspeed, while landing with the banner attached, which resulted in a failure (or inability) to attain a…Oct 3, 1993 · N5522G · Substantial damageNTSB CHI94LA005Accident · No injuriesLimited investigationFinal reportCessna 150G · Osceola, MOFracture of the number four piston at the piston pin boss. A factor related to the accident was: the lack of suitable terrain for an emergency landing.Oct 3, 1993 · N4646X · Substantial damageNTSB CHI94LA003Accident · No injuriesLimited investigationFinal reportWelch OW8M · Greenfield, INThe pilot's failure to properly flare the airplane. The gusty crosswind was a factor.Oct 3, 1993 · N17117 · Substantial damageNTSB ANC94LA005Accident · No injuriesLimited investigationFinal reportPiper PA-18-180 · Pilot Point, AKThe Pilot-in-command's failure to compensate for the crosswind during taxi. The crosswind was a factor.Oct 3, 1993 · N3680Z · Substantial damageNTSB NYC94LA003Accident · No injuriesLimited investigationFinal reportCessna 172 · Mt. Gilead, OHthe pilot's improper inflight decision to conduct a night landing at an airport without runway lights, and the subsequent misalignment with the runway and collision with an object.Oct 2, 1993 · N736RZ · Substantial damageNTSB LAX94LA002Accident · Minor injuriesLimited investigationFinal reportCessna 170 · Fallon, NVwas the pilot's failure to maintain an adequate approach path to the runway and his inadequate altitude. Contributing factors were the pilot's delayed remedial action and his lack of recent experience in the airplane.Oct 2, 1993 · N4266V · Substantial damageNTSB FTW94LA003Accident · No injuriesLimited investigationFinal reportCessna 208B · Dfw Airport, TXThe pilot's disregard for the issued safety advisory.Oct 2, 1993 · N9762B · Substantial damageNTSB CHI94LA015Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Monroe, MIThe pilot's inadequate preflight planning/preparation, when he misjudged the (inadequate) supply of fuel before takeoff, which resulted in fuel exhaustion. Soft terrain in the emergency landing area was a related factor.Oct 2, 1993 · N2759S · Substantial damageNTSB CHI94LA004Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Cheboygan, MIInadequate preflight planning/preparation by the pilot, which resulted in fuel exhaustion due to and inadequate supply of fuel. Factors related to the accident were: the lack of suitable terrain for a forced landing, and trees in the emergency landing area.Oct 2, 1993 · N5695U · DestroyedNTSB CHI94FA002Accident · 2 fatalField investigationFinal reportBeech 95 · Roodhouse, ILwas the inadequate supervision by the flight instructor which resulted in the inadvertent stall/spin by the student.Oct 2, 1993 · N2711Y · DestroyedNTSB CHI94FA001Accident · 1 fatalField investigationFinal reportBeech G35 · Webster, WIIn-flight breakup of the airplane for an undetermined reason.Oct 2, 1993 · N4421D · DestroyedNTSB ANC94FA001Accident · 1 fatalField investigationFinal reportMaule M-6-235 · Merrill Pass, AKThe pilot-in-command's attempt to fly VFR into IMC conditions. A factor was the whiteout weather condition.Oct 2, 1993 · N5647N · Substantial damageNTSB SEA94LA001Accident · No injuriesLimited investigationFinal reportBeech A35 · Heber City, UTFuel starvation brought on by the absence of the roll pin which engages the fuel selector handle to the fuel selector valve shaft, and the pilot in command's misjudging his flare resulting in a hard landing.Oct 1, 1993 · N667B · Substantial damageNTSB SEA93LA215Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Tooele, UTThe pilot in command's failure to maintain directional control. A factor contributing to the accident was the fence.Oct 1, 1993 · N21170 · Substantial damageNTSB SEA93FA214Accident · 3 fatalField investigationFinal reportCessna 172N · Ellensburg, WAThe pilot's failure to maintain an airspeed above stalling speed (vs), and his inadequate remedial action. Factors include the pilot's diverted attention, and an inadvertent stall/spin.Oct 1, 1993 · N172LS · DestroyedNTSB LAX94LA003Accident · 1 fatalLimited investigationFinal reportCessna 182H · Clear Lake Res, CAFailure of the pilot to maintain altitude, while performing a low-altitude maneuver (turn) over water. Factors related to the accident were: sun glare, haze, glassy condition of the water, and the lack of visual cues (visual perception) for the pilot to judge…Oct 1, 1993 · N8397S · Substantial damageNTSB LAX94LA001Accident · No injuriesLimited investigationFinal reportCessna O-2A · Tucson, AZwas the partial loss of engine power during initial climb due to partial clogging of the engine's fuel injectors. Blockage of the fuel injectors was due to inadequate maintenance of the fuel system by contract maintenance personnel.Oct 1, 1993 · N5151A · Substantial damageNTSB FTW94LA033Accident · Serious injuriesLimited investigationFinal reportBell 204-B · Cedar Crest, NMFailure of ground personnel to follow published procedures. A factor was the the load jettison.Oct 1, 1993 · N41699 · No damageNTSB BFO93LA192Accident · Minor injuriesLimited investigationFinal reportCessna 182F · Batavia, OHThe pilot's improper flare.Oct 1, 1993 · N3332U · Substantial damageNTSB MIA93FAMS2Accident · 1 fatalMissing aircraftFinal reportCessna 152 · FLundetermined.Sep 30, 1993 · N93261 · DestroyedNTSB LAX93LA373Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Lompoc, CAwas fuel starvation. A factor in the accident was the mechanic's inadequate inspection of the airplane.Sep 30, 1993 · N430FL · Substantial damage