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 CHI99LA270Accident · Minor injuriesLimited investigationFinal reportBeech C23 · Port Washington, WIthe loss of engine power for undetermined reasons.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB SEA99LA134Accident · No injuriesLimited investigationFinal reportCessna 182 · Middleton, IDThe pilot's failure to maintain clearance from an object. Power lines were a factor.NTSB 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…NTSB FTW99LA208Accident · Minor injuriesLimited investigationFinal reportPiper J3C-65 · Sanger, TXThe failure of the pilot-in-command to maintain clearance with the power line.NTSB 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.NTSB DEN99LA131Accident · Serious injuriesLimited investigationFinal reportCessna T210F · Fairplay, COA partial loss of engine power due to a partial failure of the turbocharger.NTSB 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.NTSB 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.NTSB 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…NTSB DCA99WA070Accident · No injuriesForeign investigationEmbraer EMB-110 · FijiNTSB 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.NTSB 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.NTSB CHI99FA263Accident · No injuriesField investigationFinal reportUnderwood Brokaw Bullet · Oshkosh, WIthe pilot failed to maintain directional control of the airplane.NTSB 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…NTSB 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.NTSB 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.NTSB 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…NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB NYC99LA184Accident · No injuriesLimited investigationFinal reportTroy Pietenpol · Collins, OHIn-flight separation of the propeller.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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…NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB NYC99FA181Accident · 1 fatalField investigationFinal reportPiper PA 22-135 · Palatine, NYThe pilot was impaired by an illegal drug, and entered an inadvertent stall/spin.NTSB 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.NTSB 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.NTSB 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…NTSB 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.