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 FTW98FA167Accident · 1 fatalField investigationFinal reportBell 206B · Round Top, TXThe pilot's attempted VFR flight into instrument meteorological conditions. Contributing factors were fog, low ceilings, and trees.NTSB SEA98LA059Accident · No injuriesLimited investigationFinal reportBeech 35-C33 · Hillsboro, ORThe flight instructor's inadequate supervision and the dual student's premature lift off which resulted in inadequate airspeed, a stall, and collision with the ground.NTSB SEA98LA058Accident · No injuriesLimited investigationFinal reportCessna 195A · Bend, ORSeparation by fracture of the left main gear leg, as the result of fatigue cracks that initiated in corrosion pits on the gear leg surface.NTSB SEA98LA057Accident · No injuriesLimited investigationFinal reportAeronca 7-EC · Glendive, MTThe pilot's delayed remedial action and his inadvertent entry into a ground loop.NTSB SEA98FA056Accident · 3 fatalField investigationFinal reportCessna P210N · Royal City, WAAttempted VFR flight into IMC and terrain clearance was not maintained. A low ceiling was a factor.NTSB MIA98LA114Accident · No injuriesLimited investigationFinal reportSouthwest Florida SW204 · Indiantown, FLA loss of engine power due to turbine blade failure caused by operating the engine in an over temperature and over speed condition. Contributing to the accident was the pilot's failure to observe the helicopter's maximum gross lift-off weight limit resulting…NTSB MIA98LA113Accident · No injuriesLimited investigationFinal reportCessna 172M · Kingsport, TNThe dual student's failure to maintain adequate airspeed which resulted in a stall mush. Contributing to the accident were the flight instructor's inadequate supervision and the night conditions.NTSB MIA98FA112Accident · Serious injuriesField investigationFinal reportBoeing 727-212 · Fort Lauderdale, FLFailure of the No.2 engine low pressure compressor rear tierod. Also contributing to the accident was failure of the manufacturer to apply an antigallant treatment to the tierod's compressor disk lands during manufacture.NTSB FTW98LA169Accident · No injuriesLimited investigationFinal reportAeronca 7DC · Wright, WYThe pilot's use of unsuitable terrain for takeoff. Factors were snow and rock covered terrain, inadequate aircraft preflight, improper aircraft servicing, and the fuel contaminated by water.NTSB FTW98LA166Accident · No injuriesLimited investigationFinal reportCessna 172F · Fort Collins, COthe pilot's improper in flight planning/decision in electing to land with a known 30 knot tailwind. Factors were high winds and a tailwind.NTSB FTW98LA163Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Riviera, TXThe pilot's failure to maintain terrain clearance while performing an evasive maneuver to avoid a charging bull, resulting in a tail rotor blade strike and the failure of the tail rotor drive shaft. Factors were the charging bull and the lack of suitable…NTSB CHI98LA112Accident · No injuriesLimited investigationFinal reportCessna 310J · Hutchinson, KSthe flight instructor's inadequate supervision by failing to ensure that the right throttle had been retarded before re-advancing the right mixture control, which resulted in a loss of directional control, an encounter with soft terrain, and damage to the…NTSB SEA98FA055Accident · No injuriesField investigationFinal reportEnstrom F28F · Baker, ORFatigue failure of the steel tubing pylon structure. Factors include inadequate inspection by maintenance personnel of damage after a previous accident.NTSB NYC98LA086Accident · No injuriesLimited investigationFinal reportGlobe Swift · Milton, DEimproper flare by the pilot, which resulted in a hard landing.NTSB MIA98LA116Accident · No injuriesLimited investigationFinal reportPiper PA-18-135 · Myrtle Beach, SCthe pilot-in-command's failure to maintain directional control after landing.NTSB LAX98LA130Accident · Minor injuriesLimited investigationFinal reportCessna 150A · Apple Valley, CAThe pilot's selection of an unsuitable landing area.NTSB IAD98LA041Accident · No injuriesLimited investigationFinal reportCessna 152 · Windsor Locks, CTThe student pilot's inattention during taxi, which resulted in the collision with a fuel truck.NTSB ANC98LA033Accident · No injuriesLimited investigationFinal reportPiper J5-C · Valdez, AKThe owner/pilot mechanic's improper overhaul of the engine, and lack of proper lubricating cylinder grease. A factor in the accident was the lack of a suitable area for a forced landing.NTSB ANC98LA032Accident · Minor injuriesLimited investigationFinal reportAerospatiale AS-350B · Soldotna, AKThe pilot's inadvertent dynamic rollover while performing a slope landing. Factors associated with the accident are the presence of rough and uneven terrain, and the pilot's improper slope landing technique.NTSB NYC98LA082Accident · No injuriesLimited investigationFinal reportCessna 172P · Plainville, CTThe pilot's inadequate crosswind compensation.NTSB MIA98LA111Accident · No injuriesLimited investigationFinal reportSteen Skybolt · Sanford, FLThe failure of the pilot of N101DT to maintain a visual lookout during the taxi phase of his flight and the failure of the ground controller to issue a traffic advisory to N101DT about the location of N6285M.NTSB MIA98FA110Accident · Serious injuriesField investigationFinal reportCessna 150H · West Palm Beach, FLThe poor in-flight planning by the pilot-in-command for his failure to ask for assistance after becoming lost momentarily, and his failure to monitor the total time airborne after the fuel tanks were filled. Contributing to the accident was the binding of the…NTSB ATL98LA061Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Hampton, GAThe pilot's failure to maintain directional control during a full stop landing roll.NTSB NYC98LA084Accident · No injuriesLimited investigationFinal reportCessna 140 · Linden, NJThe pilot in commands improper recovery from a bounced landing.NTSB MIA98FAMS2Accident · 1 fatalMissing aircraftFinal reportCessna 182H · MissingUndetermined.NTSB IAD98LA040Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Red Hook, NYinadequate compensation for the crosswind by the pilot, and his failure to maintain directional control during the landing. Related factors were: the gusty crosswind condition, and high vegetation that was encountered after departing the runway.NTSB FTW98LA162Accident · Minor injuriesLimited investigationFinal reportCarter LONG-EZ · Lebanon, OKThe pilot's inadequate compensation for the tailwind and his ensuing failure to attain the proper touchdown point. Factors were the tailwind and the pilot's failure to adequately preflight the airplane which resulted in a partial loss of engine power due to…NTSB FTW98LA161Accident · Serious injuriesLimited investigationFinal reportGrumman G-164 · St. Joseph, LAThe pilot's failure to maintain clearance from the trees. A factor was the lack of suitable terrain for the ensuing forced landing.NTSB CHI98LA109Accident · Minor injuriesLimited investigationFinal reportCessna 180 · Whitewood, SDfailure of the pilot to maintain clearance from obstructions (wires) during an approach for a precautionary landing. Factors associated with the accident were: the pilot's inadequate evaluation of the weather conditions, low ceilings, icing conditions, and…NTSB NYC98LA085Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 8B-15 · Elk Garden, VAthe pilot's improper weather evaluation. The gusty wind condition was a related factor.NTSB NYC98LA083Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Milford Center, OHthe pilot's excessive application of brakes during an aborted takeoff roll.NTSB MIA98LA109Accident · No injuriesLimited investigationFinal reportMooney M20J · Daytona Beach, FLthe student's failure to maintain control of the airplane, and the CFI's inadequate supervision. A factor was that the CFI allowed the airplane's sink rate to get excessive during the approach.NTSB SEA98LA053Accident · No injuriesLimited investigationFinal reportCessna 150G · Hailey, IDA fractured nosewheel steering linkage bolt, which permitted the nosewheel steering linkage to become disconnected, and the student pilot's subsequent failure to restore directional control by use of differential wheel braking.NTSB LAX98LA145Accident · Minor injuriesLimited investigationFinal reportDuskin Rans S-14 · Hemet, CAthe pilot's loss of aircraft control during landing, and his physical impairment from a blood alcohol level of 0.07 percent 2 hours following the accident.NTSB LAX98LA125Accident · Serious injuriesLimited investigationFinal reportCessna 150G · Sonoma, CAThe instructor pilot's inadequate in-flight planning/decision and subsequent inadequate supervision of the situation to simulate an engine failure on takeoff, as well as both pilot's not maintaining a visual lookout. A related factor was the diverted…NTSB FTW98LA160Accident · Minor injuriesLimited investigationFinal reportAero Commander 100 · Fort Worth, TXThe separation of the aileron control rod due to bending overstress. A factor was the unsuitable terrain available for the precautionary landing.NTSB FTW98FA165Accident · 2 fatalField investigationFinal reportVelocity 173 RG Elite · N. Little Rock, ARInadequate fusion between the valve stem and head due to inadequate quality control during construction of the exhaust valve for the number three cylinder. A contributing factor was the lack of suitable terrain for the forced landingNTSB CHI98LA113Accident · No injuriesLimited investigationFinal reportCessna 310R · Sioux Falls, SDthe pilot's failure to extend the landing gear for landing. Factors associated with the accident were: the crosswind, and the pilot not following his normal habit pattern of lowering the landing gear on base leg.NTSB MIA98LA108Accident · No injuriesLimited investigationFinal reportGreat Lakes 2T-1A-2 · Pierson, FLthe pilot's failure to note the windsock before touchdown which resulted in a downwind landing, and the pilot's improper elevator control. Factors were the tailwind and the pilot's complacency.NTSB LAX98LA129Accident · No injuriesLimited investigationFinal reportAyres S2RT-34RE · Buckeye, AZThe incorrect turbine blades installed on the engine, the fractured compressor turbine blades and separation of the blade, and the improper maintenance installation of the incorrect CT blades by the repair station. A factor in the accident was the inadequate…NTSB FTW98LA164Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Tuckerman, ARThe pilot's failure to maintain aircraft control. Factors were the wet and soft runway conditions.NTSB FTW98LA159Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Norman, OKThe pilot's improper compensation for wind conditions, which resulted in a loss of directional control and collision with a ditch. A contributing factor was the high crosswind.NTSB FTW98IA158Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-10-10 · Denver, COThe total failure of one main landing gear tire.NTSB ANC98LA031Accident · No injuriesLimited investigationFinal reportCessna 172A · Paxson, AKThe pilots failure to maintain terrain clearance while flying into a box canyon, and an inadvertent stall during his attempt to reverse direction.NTSB SEA98LA052Accident · No injuriesLimited investigationFinal reportBeech S35 · Medford, ORthe pilot's inadequate fuel management. Factors were the pilot's diverted attention and soft terrain in the forced landing area.NTSB SEA98LA051Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Kalispell, MTThe pilot's failure to maintain adequate crosswind correction during landing. A factor was a crosswind.NTSB MIA98LA105Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Punta Gorda, FLThe total loss of engine power due to fuel starvation.NTSB LAX98LA128Accident · No injuriesLimited investigationFinal reportAir Tractor AT301 · Imperial, CAThe pilot's selection of the wrong runway, which resulted in a downwind takeoff attempt, and, his failure to obtain/maintain a proper airspeed during the takeoff sequence. The aircraft's gross weight and the prevailing density altitude were factors in the…NTSB FTW98LA168Accident · No injuriesLimited investigationFinal reportBoeing A75N (PT-17) · Grand Junction, COFailure by the pilot to maintain control of the aircraft during landing roll. Factors were variable winds and the pilot's lack of recent experience in make and model.NTSB FTW98FA157Accident · Serious injuriesField investigationFinal reportCessna T207A · Monument Valley, UTThe engine's total power loss due to the induction air ducting separating because of inadequate maintenance by company personnel. Factors were the failure of the manufacturer to provide non-standard operating procedures in their airplane's information manual,…