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.
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
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
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.NTSB 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.NTSB 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.NTSB CHI98FA187Accident · 1 fatalField investigationFinal reportCessna 421 · Little Falls, MNthe pilot's continued operation with a known deficiency in equipment.NTSB 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.NTSB NYC98WA123Accident · No injuriesForeign investigationPiper PA-32-260 · Nice, FranceNTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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,…NTSB 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…NTSB SEA98FA083Accident · 2 fatalField investigationFinal reportPapa 51 Thunder Mustang · Marsing, IDThe pilot's failure to maintain adequate airspeed which resulted in a stall.NTSB 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.NTSB 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 controlNTSB 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.NTSB 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.NTSB DCA98WA059Accident · 2 fatalForeign investigationRans Airaile S 12 · Sligo Airport, IrelandNTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB DCA98WA048Accident · No injuriesForeign investigationBoeing B-737-500 · Bombay, IndiaNTSB 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.NTSB 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.NTSB 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…NTSB MIA98LA170Accident · No injuriesLimited investigationFinal reportBell 47G · Bunnell, FLThe pilot-in-command(CFI) failure to maintain control of the aircraft.NTSB FTW98LA247Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Claremore, OKThe pilot's failure to maintain obstacle clearance.NTSB 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.NTSB 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.NTSB MIA98LA171Accident · Minor injuriesLimited investigationFinal reportBeech 95 · Jacksonville, FLThe pilot's failure to maintain airspeed (VSO) on final approach resulting in an inadvertent stall.NTSB 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…NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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…NTSB MIA98LA168Accident · No injuriesLimited investigationFinal reportGulfstream American 690C · Jacksonville, FLthe left main landing gear failed to extend due to a jammed link assembly.NTSB DCA98WA052Accident · No injuriesForeign investigationRobinson R22 Beta · Redhill Aerodro, United KingdomNTSB 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.NTSB CHI98FA172Accident · 1 fatalField investigationFinal reportPiper J-3C · Morris, ILThe pilot's failure to maintain aircraft control during low altitude flight.NTSB 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…NTSB 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.NTSB 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…NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB CHI98LA174Accident · No injuriesLimited investigationFinal reportCessna 310L · Wheeling, ILthe collapse of the left main landing gear for undetermined reasons.