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 FTW98LA251Accident · No injuriesLimited investigationFinal reportCessna 170B · Los Alamos, NMThe pilot's inadequate compensation for the wind conditions. Contributing factors were the crosswinds, the fence, and the ditch.Jun 1, 1998 · N1896C · Substantial damageNTSB CHI98LA188Accident · Minor injuriesLimited investigationFinal reportCessna 175A · Norfolk, NEthe pilot's misjudged wind conditions and his not obtaining/maintaining compensation for wind conditions. A factor was a sudden wind shift.Jun 1, 1998 · N6847E · DestroyedNTSB CHI98LA185Accident · No injuriesLimited investigationFinal reportCessna 150M · Newton, KSthe pilot's inadequate preflight planning/preparation which led to fuel exhaustion and subsequent loss of engine power. Related factors were the pilot became disoriented and a dark night.Jun 1, 1998 · N714FB · Substantial damageNTSB CHI98FA187Accident · 1 fatalField investigationFinal reportCessna 421 · Little Falls, MNthe pilot's continued operation with a known deficiency in equipment.Jun 1, 1998 · N541N · DestroyedNTSB ANC98LA063Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Talkeetna, AKThe pilot's failure to maintain adequate altitude/clearance from rising terrain. A factor associated with the accident was rising terrain.Jun 1, 1998 · N4587A · Substantial damageNTSB NYC98WA123Accident · No injuriesForeign investigationPiper PA-32-260 · Nice, FranceMay 31, 1998 · N3995W · Substantial damageNTSB LAX98LA178Accident · Serious injuriesLimited investigationFinal reportFields Baby Belle · Inyokern, CAThe failure of the pilot to recover from a low rotor rpm condition, which resulted in a loss of aircraft control.May 31, 1998 · N656VK · DestroyedNTSB FTW98LA255Accident · No injuriesLimited investigationFinal reportCessna 150L · Pearland, TXThe pilot's selection of the wrong runway/landing area. A factor was the lack of visual runway cues available to the pilot.May 31, 1998 · N19271 · Substantial damageNTSB FTW98LA250Accident · Minor injuriesLimited investigationFinal reportPiper PA-22 · Balko, OKThe pilot's inadequate preflight planning which failed to assure adequate climb performance to clear an obstacle (fence) during takeoff climb.May 31, 1998 · N200HA · Substantial damageNTSB FTW98FA248Accident · 1 fatalField investigationFinal reportJacob Tussel Everett B1 · Stanley, NMThe pilot's intentional performance of an aerobatic maneuver at an altitude insufficient for a safe recovery.May 31, 1998 · N30BP · DestroyedNTSB CHI98LA181Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · Sikesville, MOthe deer which ran in front of the airplane during the landing flare. Factors associated with the accident were the inadequate airspeed which resulted in the pilot not being able to maintain directional control of the airplane as he attempted to avoid deer,…May 31, 1998 · N9324N · Substantial damageNTSB ANC98FA061Accident · 2 fatalField investigationFinal reportAerospatiale AS-350-B2 · Juneau, AKThe failure of both command pilots to maintain an adequate lookout to see and avoid each other's aircraft. Factors associated with the accident were the pilot's failure to follow published advisory procedures to monitor/issue position reports on the…May 31, 1998 · N187EH · 2 aircraft · Substantial damageNTSB SEA98FA083Accident · 2 fatalField investigationFinal reportPapa 51 Thunder Mustang · Marsing, IDThe pilot's failure to maintain adequate airspeed which resulted in a stall.May 30, 1998 · N151TM · DestroyedNTSB LAX98LA317Accident · No injuriesLimited investigationFinal reportPiper PA-28-150 · Victorville, CAThe installation of incorrect washers for the brake manifold by maintenance personnel, which resulted in the left brake locking up, which made it impossible for the pilot to maintain directional control of the aircraft.May 30, 1998 · N5962W · Substantial damageNTSB LAX98LA177Accident · No injuriesLimited investigationFinal reportRans S6EX Coyote II · Delano, CAThe pilot's inadequate compensation for wind conditions, failure to maintain directional control, and his failure to maintain aircraft controlMay 30, 1998 · N6179A · Substantial damageNTSB IAD98LA066Accident · Minor injuriesLimited investigationFinal reportCessna 170B · Wadsworth, OHThe flight instructor's failure to maintain control of the airplane which resulted in his intentional ground loop. A factor in the accident was the flight instructor's lack of currency in tailwheel airplanes.May 30, 1998 · N3099A · Substantial damageNTSB IAD98LA064Accident · No injuriesLimited investigationFinal reportCessna 172D · Beverly, MAfailure of the pilot to maintain control of the airplane during the landing and attempted go-around. A related factor was the crosswind.May 30, 1998 · N2507Y · Substantial damageNTSB DCA98WA059Accident · 2 fatalForeign investigationRans Airaile S 12 · Sligo Airport, IrelandMay 30, 1998 · DMLAB · DestroyedNTSB CHI98LA184Accident · No injuriesLimited investigationFinal reportBalloon Works Firefly 7-15 · Waterloo, IAThe pilot's failure to maintain clearance with the power lines during climb. A factor was the power lines.May 30, 1998 · N25491 · Substantial damageNTSB CHI98LA183Accident · Minor injuriesLimited investigationFinal reportLuscombe 8E · Montague, MIthe pilot's improper use of carburetor heat which resulted in the formation of carburetor ice and the loss of engine power. Factors to the accident were the carburetor icing conditions and the trees.May 30, 1998 · N1968K · Substantial damageNTSB ANC98LA060Accident · No injuriesLimited investigationFinal reportCessna U206 · Fairbanks, AKThe pilot's inadequate compensation for wind conditions. Factors associated with the accident are variable winds, and windshear.May 30, 1998 · N414UJ · Substantial damageNTSB FTW98LA249Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Iowa, LApartial loss of engine power during takeoff for undetermined reason(s). The obstructions (trees & dirt bank) were related factors.May 29, 1998 · N8629H · Substantial damageNTSB FTW98LA242Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-1C · Roanoke, TXThe loss of engine power resulting from an excessively rich mixture for an undetermined reason. A factor was the lack of suitable terrain for the forced landing.May 29, 1998 · N9606U · Substantial damageNTSB DCA98WA048Accident · No injuriesForeign investigationBoeing B-737-500 · Bombay, IndiaMay 29, 1998 · UNK · Substantial damageNTSB CHI98LA180Accident · Minor injuriesLimited investigationFinal reportBeech F35 · Orleans, NEthe pilot selected a field with unsuitable terrain and stalled the airplane. Additional factors were the tower in the field, and engine failure due to the improper torque applied to camshaft bolts by other maintenance personnel.May 29, 1998 · N1AG · DestroyedNTSB ANC98TA062Accident · Minor injuriesFinal reportCessna 185 · Kotzebue, AKThe instructor pilot's inadequate compensation for wind conditions. A factor associated with this accident was a downdraft prior to touchdown.May 29, 1998 · N4761Q · Substantial damageNTSB ANC98LA059Accident · No injuriesLimited investigationFinal reportCessna 207 · Bethel, AKThe throttle arm disconnecting from the throttle linkage to the engine as a result of inadequate inspection by company maintenance personnel. Factors associated with this accident were the company maintenance personnel not following the repetitive Service…May 29, 1998 · N9956M · Substantial damageNTSB MIA98LA170Accident · No injuriesLimited investigationFinal reportBell 47G · Bunnell, FLThe pilot-in-command(CFI) failure to maintain control of the aircraft.May 28, 1998 · N182JR · Substantial damageNTSB FTW98LA247Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Claremore, OKThe pilot's failure to maintain obstacle clearance.May 28, 1998 · N6256S · Substantial damageNTSB CHI98LA179Accident · No injuriesLimited investigationFinal reportCessna 177RG · Tocsin, INthe pilot's failure to obtain adequate airspeed during the takeoff climb and the resulting inadvertant stall. A factor in the accident was the pilot's premature raising of the flaps.May 28, 1998 · N1849Q · Substantial damageNTSB CHI98LA178Accident · Minor injuriesLimited investigationFinal reportCessna 414 · North Platte, NEthe slipped number two bearing in the airplane's right engine, which blocked the bearing's oil feed line, causing the bearing and the crankshaft to overheat and fracture. A factor contributing to this accident was the trees.May 28, 1998 · N888AA · DestroyedNTSB MIA98LA171Accident · Minor injuriesLimited investigationFinal reportBeech 95 · Jacksonville, FLThe pilot's failure to maintain airspeed (VSO) on final approach resulting in an inadvertent stall.May 27, 1998 · N2705Y · Substantial damageNTSB FTW98LA245Accident · No injuriesLimited investigationFinal reportCessna 320B · Rockport, TXThe pilot's failure to maintain airspeed during a go around which resulted in an inadvertent stall. Factors were the pilot's lack of experience in the make and model aircraft, his failure to follow the before landing checklist, and his improper use of the…May 27, 1998 · N986J · Substantial damageNTSB CHI98LA176Accident · Minor injuriesLimited investigationFinal reportWaters Vortex · Monroe, WIthe pilot's failure to maintain rotor RPM. A factor associated with the accident was the soft terrain on which the gyrocopter touched down.May 27, 1998 · N1025Y · Substantial damageNTSB CHI98LA175Accident · No injuriesLimited investigationFinal reportBoeing Stearman A75-N1 · West Fargo, NDthe pilot's failure to assure an adequate fuel supply in order to complete the flight. A factor associated with the accident was the soft terrain on which the forced landing was made.May 27, 1998 · N49955 · Substantial damageNTSB ANC98LA058Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Paxson, AKA loss of engine power due to a failure of the engine's number 3 intake valve. A factor in the accident was the unsuitable terrain for a forced landing.May 27, 1998 · N1322B · Substantial damageNTSB ANC98LA057Accident · Minor injuriesLimited investigationFinal reportCessna 206 · Tyonek, AKThe pilot's continued flight into adverse weather conditions, and his inadequate in-flight planning/decision. Factors in the accident were weather conditions consisting of a mountain wave, and downdrafts.May 27, 1998 · N5297U · Substantial damageNTSB NYC98FA117Accident · 1 fatalField investigationFinal reportMorelli Rans S9 · Taunton, MAThe pilot's operation of the aircraft in an unapproved configuration contrary to procedures resulting in diminished aircraft control, and his failure to maintain control of the aircraft resulting in a stall/spin event. Contributing factors were the…May 26, 1998 · N1189Z · DestroyedNTSB MIA98LA168Accident · No injuriesLimited investigationFinal reportGulfstream American 690C · Jacksonville, FLthe left main landing gear failed to extend due to a jammed link assembly.May 26, 1998 · N840V · Substantial damageNTSB DCA98WA052Accident · No injuriesForeign investigationRobinson R22 Beta · Redhill Aerodro, United KingdomMay 26, 1998 · BOAMNTSB CHI98LA177Accident · No injuriesLimited investigationFinal reportMooney M20J · Lincoln, NEthe pilot of N60BH failed to maintain clearance with N11498. Factors associated with the accident were the diminished visual lookout due to the runway and the tail wheel configuration of N60HB, along with the controllers failure to point out traffic.May 26, 1998 · N11498 · 2 aircraft · Substantial damageNTSB CHI98FA172Accident · 1 fatalField investigationFinal reportPiper J-3C · Morris, ILThe pilot's failure to maintain aircraft control during low altitude flight.May 26, 1998 · N24743 · DestroyedNTSB NYC98LA119Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Hanover, PAfailure of the pilot to obtain current information for the divert airfield, and his selection of an unsuitable area for landing. Related factors included: the lower ambient light conditions at dusk, construction on the airfield, and an over-reliance on the…May 25, 1998 · N43108 · Substantial damageNTSB NYC98GA113Accident · 2 fatalFinal reportCessna 182R · Middleborough, MAThe pilot-in-command's failure to maintain control of the airplane during a VFR go-around. A factor was the impairment due to drugs.May 25, 1998 · N9885E · DestroyedNTSB NYC98FA112Accident · 2 fatalField investigationFinal reportBeech A36 · Middletown, RIThe shift of the number 2 engine bearing, which in turn blocked oil lubrication, and resulted in crankshaft failure. Also causal, was the pilot's decision to continue toward the airport instead of performing a forced landing to an available field. Factors…May 25, 1998 · N4507S · DestroyedNTSB MIA98LA169Accident · No injuriesLimited investigationFinal reportMohr Skybolt · Lakeland, FLthe failure of the pilot to maintain directional control of the airplane, after landing, resulting in the airplane departing the left side of the runway and subsequent impact with the ground.May 25, 1998 · N6JJ · Substantial damageNTSB LAX98LA175Accident · No injuriesLimited investigationFinal reportMooney M20F · Las Vegas, NVThe pilot's improper remedial action in controlling the aircraft during a go-around in a crosswind which resulted in a collision with a runway light and separation of the landing gear.May 25, 1998 · N6453Q · Substantial damageNTSB IAD98LA063Accident · No injuriesLimited investigationFinal reportCessna 175 · Pemberton, NJThe pilot's inadequate fuel consumption calculations and his improper in-flight decision to continue flying with an inadequate fuel supply.May 25, 1998 · N6577E · Substantial damageNTSB FTW98LA243Accident · Serious injuriesLimited investigationFinal reportBoeing 757-2B7 · Wichita, KSThe severe turbulence encountered as a result of the flightcrew's inadvertent flight into a rapidly developing thunderstorm.May 25, 1998 · N619AU · No damageNTSB CHI98LA174Accident · No injuriesLimited investigationFinal reportCessna 310L · Wheeling, ILthe collapse of the left main landing gear for undetermined reasons.May 25, 1998 · N333WD · Substantial damage