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 CHI99LA270Accident · Minor injuriesLimited investigationFinal reportBeech C23 · Port Washington, WIthe loss of engine power for undetermined reasons.Jul 31, 1999 · N24670 · Substantial damageNTSB CHI99LA268Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-401B · Edelstein, ILan inadequate fuel supply which resulted in fuel exhaustion. Factors associated with the accident were the low altitude at which the power loss occurred and the corn crop the airplane contacted.Jul 31, 1999 · N61775 · Substantial damageNTSB CHI99LA265Accident · No injuriesLimited investigationFinal reportCessna 310N · Eden Prairie, MNmaintenance personnel installed washers which were not large enough in diameter to prevent the retraction/extension scissors links from separating from each other.Jul 31, 1999 · N310DE · Substantial damageNTSB ANC99LA116Accident · No injuriesLimited investigationFinal reportCessna 206 · Talkeetna, AKA leak/partial failure of the left main gear brake system. Factors in the accident were a short runway/landing area, and the presence of rocks/boulders at the end of the airstrip.Jul 31, 1999 · N3831G · Substantial damageNTSB ANC99LA100Accident · No injuriesLimited investigationFinal reportHughes 369D · Petersburg, AKThe pilot's failure to refuel the helicopter prior to fuel exhaustion. Factors associated with the accident were an inoperative low fuel warning system, and the pilot's improper autorotation.Jul 31, 1999 · N103FW · Substantial damageNTSB SEA99LA134Accident · No injuriesLimited investigationFinal reportCessna 182 · Middleton, IDThe pilot's failure to maintain clearance from an object. Power lines were a factor.Jul 30, 1999 · N5510B · Substantial damageNTSB MIA99LA207Accident · No injuriesLimited investigationFinal reportCessna 172M · Pierson, FLthe flight instructor's (pilot in command) failure to achieve the proper touch down point, his improper decision to continue the touch and go, and failure to abort the takeoff in sufficient time, resulting in the aircraft overrunning the runway and colliding…Jul 30, 1999 · N9880V · Substantial damageNTSB FTW99LA208Accident · Minor injuriesLimited investigationFinal reportPiper J3C-65 · Sanger, TXThe failure of the pilot-in-command to maintain clearance with the power line.Jul 30, 1999 · N42378 · Substantial damageNTSB FTW99LA206Accident · No injuriesLimited investigationFinal reportMooney M20J · Mount Pleasant, TXThe separation of the fuel line fitting as a result of fatigue. A factors was the lack of suitable terrain for a forced landing.Jul 30, 1999 · N91FH · Substantial damageNTSB DEN99LA131Accident · Serious injuriesLimited investigationFinal reportCessna T210F · Fairplay, COA partial loss of engine power due to a partial failure of the turbocharger.Jul 30, 1999 · N6125R · Substantial damageNTSB CHI99LA271Accident · No injuriesLimited investigationFinal reportCessna 180K · Shawano, WIthe failure of the pilot to maintain directional control. Factors were the misjudged flare and improper recovery from the bounced landing by the pilot, and the ditch.Jul 30, 1999 · N4809E · Substantial damageNTSB CHI99FA267Accident · 1 fatalField investigationFinal reportAir Tractor AT502B · Giltner, NEThe pilot's inadequate visual lookout, and his failure to maintain clearance from the guy wire. A factor was the guy wire.Jul 30, 1999 · N5008Z · DestroyedNTSB MIA99TA206Accident · No injuriesFinal reportHughes OH-6A · Aguadilla, PRAn unidentified foreign object passing through the oil cooler blower assembly resulting in fracture and seizure of the oil cooler blower, and slowing of the main transmission and main rotor, which resulted in the pilot being unable to arrest the descent…Jul 29, 1999 · N66377 · Substantial damageNTSB DCA99WA070Accident · No injuriesForeign investigationEmbraer EMB-110 · FijiJul 29, 1999 · UNK · DestroyedNTSB CHI99FA266Accident · Serious injuriesField investigationFinal reportChance Vought F4U-4 · Oshkosh, WIThe pilot of the other airplane not following the instructions briefed by the formation leader, and the pilot's maneuvering his airplane to avoid the airplane in front of him.Jul 29, 1999 · N712RD · 3 aircraft · DestroyedNTSB CHI99FA264Accident · 1 fatalField investigationFinal reportBeech C23 · Detroit Lakes, MNAircraft control not obtained/maintained by the pilot. A factor to the accident was the pilot's impairment due to drugs.Jul 29, 1999 · N6996R · DestroyedNTSB CHI99FA263Accident · No injuriesField investigationFinal reportUnderwood Brokaw Bullet · Oshkosh, WIthe pilot failed to maintain directional control of the airplane.Jul 29, 1999 · N331TB · Substantial damageNTSB ANC99LA099Accident · No injuriesLimited investigationFinal reportBoeing 747-269B · Anchorage, AKThe failure of a turbine blade, and subsequent penetration of the shroud (containment ring). A factor associated with the accident was the FAA's insufficient design standards/requirements addressed in an FAA Air Worthiness Directive, which called for a…Jul 29, 1999 · N707CK · Substantial damageNTSB ANC99LA098Accident · No injuriesLimited investigationFinal reportCessna 172 · Sheldon Point, AKThe pilot's inadequate compensation for the gusty crosswind conditions during takeoff. Factors associated with the accident were a crosswind, and wind gusts.Jul 29, 1999 · N79169 · Substantial damageNTSB MIA99LA205Accident · No injuriesLimited investigationFinal reportCessna R172K · Pontotoc, MSa complete loss of engine power due to the failure of the oil pressure pump, resulting in oil starvation, a forced landing and subsequent nose over.Jul 28, 1999 · N1092V · Substantial damageNTSB MIA99LA204Accident · Serious injuriesLimited investigationFinal reportRockwell S-2R · Isola, MSFailure of the No. 4 cylinder due to a leaking intake valve resulting in loss of engine power and collision with a ditch while making a forced landing on unsuitable terrain. Contributing to the accident was improper maintenance adjustment of the engine valves…Jul 28, 1999 · N8482V · DestroyedNTSB FTW99FA201Accident · 1 fatalField investigationFinal reportAerospatiale ATR-42-500 · Little Rock, ARThe station manager's inadvertent encounter with the rotating propeller due to his diverted attention.Jul 28, 1999 · N14451 · Minor damageNTSB CHI99LA275Accident · No injuriesLimited investigationFinal reportFairchild 24 C8C · La Fayette, ILthe pilot's failure to obtain/maintain the proper descent rate. A factor to the accident was the partial loss of engine power as a result of the exhaust valve keeper becoming unlocked, which jammed the exhaust valve.Jul 28, 1999 · N15345 · Substantial damageNTSB CHI99LA262Accident · No injuriesLimited investigationFinal reportBeech C-45H · Grain Valley, MOthe failure of the pilot to use the tailwheel lock on takeoff, creating a condition where it was not possible for the pilot to maintain directional control. Factors were the unlocked tailwheel and the ditch.Jul 28, 1999 · N72409 · Substantial damageNTSB CHI99FA260Accident · No injuriesField investigationFinal reportBurns Pietenpol AIR Camper · Oshkosh, WIthe pilot failed to maintain directional control and ground looped the airplane. Factors included the crosswind and the turbulence from the DC-3.Jul 28, 1999 · N350MB · Substantial damageNTSB FTW99LA202Accident · No injuriesLimited investigationFinal reportCessna A150M · Alvin, TXThe flight instructor's excessive rotation while performing a soft field takeoff, which resulted in a delayed lift-off and the ensuing failure to attain obstacle clearance.Jul 27, 1999 · N2721J · Substantial damageNTSB DEN99LA130Accident · Minor injuriesLimited investigationFinal reportAmerican AA-1 · Centennial, WYThe pilot's failure to consult the airplane performance charts and allowing the airplane to exceed its climb performance. Factors were high density altitude conditions and a downdraft.Jul 27, 1999 · N5989L · Substantial damageNTSB CHI99LA257Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Jetmore, KSThe pilot's use of improper procedures by not following the helicopter manufacturer's recommended engine RPM reduction procedures during autorotations. A factor was the pilot not attaining the proper rotor RPM during the autorotation practice.Jul 27, 1999 · N88007 · Substantial damageNTSB CHI99FA252Accident · Minor injuriesField investigationFinal reportCessna 182D · Fond Du Lac, WIthe pilot's inaccurate fuel consumption calculations and the subsequent fuel exhaustion. Factors associated with the accident were the crops and the soft field conditions.Jul 27, 1999 · N8878X · Substantial damageNTSB NYC99LA184Accident · No injuriesLimited investigationFinal reportTroy Pietenpol · Collins, OHIn-flight separation of the propeller.Jul 26, 1999 · N6286A · Substantial damageNTSB LAX99LA259Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Hayward, CAthe pilot's failure to apply carburetor heat to prevent the formation of carburetor ice while operating in IFR conditions which resulted in the loss of engine power.Jul 26, 1999 · N5539W · Substantial damageNTSB FTW99LA237Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Heber Springs, ARThe pilot's excessive approach airspeed resulting in the airplane overrunning the runway, and his failure to maintain aircraft control during the landing roll.Jul 26, 1999 · N7605J · Substantial damageNTSB FTW99LA204Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Victoria, TXThe separation of the engine cowling due to a fractured support bracket, which resulted in the cowling striking and bending four engine push rods causing a loss of engine power. A factor was the lack of suitable terrain for the forced landing.Jul 26, 1999 · N4393S · Substantial damageNTSB DEN99LA129Accident · No injuriesLimited investigationFinal reportBoeing A-75-N1 (Stearman) · Tooele, UTThe failure of the right main landing gear tire's inner tube, and the subsequent inadvertent ground loop by the pilot.Jul 26, 1999 · N56772 · Substantial damageNTSB CHI99LA282Accident · No injuriesLimited investigationFinal reportCessna 152 · Superior, WIthe student pilot's failure to maintain directional control of the airplane. Factors associated with the accident were the gusty wind condition, the student's lack of experience, and the soft terrain encountered.Jul 26, 1999 · N68268 · Substantial damageNTSB CHI99LA273Accident · No injuriesLimited investigationFinal reportMooney M20B · Hayward, WIthe pilot's failure to maintain clearance with the surface of the lake. Factors associated with the accident were the low level flight, dusk light conditions, and the glassy water.Jul 26, 1999 · N74523 · Substantial damageNTSB CHI99LA256Accident · Minor injuriesLimited investigationFinal reportPiper PA-31-350 · Salina, KSthe inadequate preflight inspection by the pilot. Factors to the accident were fuel exhaustion and the operation of the aircraft with known deficiencies in equipment by the pilot.Jul 26, 1999 · N97MA · Substantial damageNTSB ATL99LA114Accident · No injuriesLimited investigationFinal reportMaule M-5-200 · St.Simons, GAThe inadequate installation of the magneto assembly by other maintenance personnel that in resulted the separation from the engine and the subsequent loss of engine power. A factor was the swampy terrain condition.Jul 26, 1999 · N5643T · Substantial damageNTSB SEA99LA130Accident · No injuriesLimited investigationFinal reportPiper PA-18A-150 · Jordan Valley, ORThe pilot's inadvertent stall/mush of the aircraft while attempting a forced landing due to partial power loss of the engine. Factors include carburetor icing conditions and the pilot's improper use of carburetor heat.Jul 25, 1999 · N3992P · Substantial damageNTSB LAX99LA258Accident · No injuriesLimited investigationFinal reportCessna 172N · Prescott, AZthe student pilot's premature retraction of the flaps during an aborted landing and his failure to obtain/maintain adequate flying airspeed, which resulted in a stall/mush condition and the airplane settling back onto the ground. The student pilot's failure…Jul 25, 1999 · N5535D · Substantial damageNTSB CHI99LA253Accident · No injuriesLimited investigationFinal reportBeech B36TC · Brookfield, MOthe total mechanical failure of the engine crankshaft due to fatigue. A factor was the ditch encountered on landing.Jul 25, 1999 · N587DL · Substantial damageNTSB SEA99LA129Accident · 3 fatalLimited investigationFinal reportVanek Sport Copter · Scappoose, ORThe failure of the ultralight operator to see and avoid the landing gyroplane, and the gyroplane pilot's inability to see the departing ultralight vehicle.Jul 24, 1999 · N61887 · 2 aircraft · DestroyedNTSB SEA99LA128Accident · No injuriesLimited investigationFinal reportGlobe GC-1B · Spokane, WAThe pilot's failure to maintain directional control. A related factor was the pilot's lack of experience in tailwheel aircraft.Jul 24, 1999 · N80622 · Substantial damageNTSB SEA99LA127Accident · No injuriesLimited investigationFinal reportBeech D17S · Arco, IDFuel starvation which resulted in a loss of power. The pilot's improper management of fuel was a factor.Jul 24, 1999 · N217SD · Substantial damageNTSB NYC99LA185Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Manville, NJThe pilot's failure to follow the checklist and improper use of the carburetor heat. A factor in the accident was determined to be the density altitude.Jul 24, 1999 · N714HS · Substantial damageNTSB NYC99FA181Accident · 1 fatalField investigationFinal reportPiper PA 22-135 · Palatine, NYThe pilot was impaired by an illegal drug, and entered an inadvertent stall/spin.Jul 24, 1999 · N8937C · Substantial damageNTSB MIA99LA202Accident · No injuriesLimited investigationFinal reportBeech C23 · Seneca, SCthe pilot misjudged the flare, landed hard, bounced, departed the runway, which resulted in an impact with a ditch and embankment. A factor in this accident was the improper recovery from a bounced landing.Jul 24, 1999 · N63TW · Substantial damageNTSB MIA99LA201Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Ormond Beach, FLa loss of engine power due to a stuck exhaust valve which resulted in a forced landing, the subsequent impact with the ground, and nose over.Jul 24, 1999 · N19222 · Substantial damageNTSB LAX99LA322Accident · No injuriesLimited investigationFinal reportBoeing 757-2G7 · Phoenix, AZThe failure of the flight crew and the tug driver to verify that the aircraft was properly configured for pushback. Factors in the accident were the left wing walker's failure to notify the tug driver of his observations that the jet bridge was still in…Jul 24, 1999 · N910AW · Substantial damageNTSB LAX99LA257Accident · No injuriesLimited investigationFinal reportEwertz Starduster II · Winslow, AZthe pilot's failure to attain and maintain a sufficient flying airspeed for the existing density altitude conditions, which resulted in an inadvertent stall/mush.Jul 24, 1999 · N102E · Substantial damage