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 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.Apr 2, 1998 · N7734A · DestroyedNTSB 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.Apr 1, 1998 · N1310A · Substantial damageNTSB 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.Apr 1, 1998 · N1069D · Substantial damageNTSB SEA98LA057Accident · No injuriesLimited investigationFinal reportAeronca 7-EC · Glendive, MTThe pilot's delayed remedial action and his inadvertent entry into a ground loop.Apr 1, 1998 · N4382C · Substantial damageNTSB 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.Mar 31, 1998 · CGBFM · DestroyedNTSB 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…Mar 31, 1998 · N106CP · Substantial damageNTSB 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.Mar 31, 1998 · N9233H · DestroyedNTSB 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.Mar 31, 1998 · CFRYS · Minor damageNTSB 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.Mar 31, 1998 · N4484E · Substantial damageNTSB 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.Mar 31, 1998 · N7894U · Substantial damageNTSB 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…Mar 31, 1998 · N2628B · Substantial damageNTSB 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…Mar 31, 1998 · N3020L · Substantial damageNTSB 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.Mar 30, 1998 · N171HH · Substantial damageNTSB NYC98LA086Accident · No injuriesLimited investigationFinal reportGlobe Swift · Milton, DEimproper flare by the pilot, which resulted in a hard landing.Mar 30, 1998 · N10JN · Substantial damageNTSB MIA98LA116Accident · No injuriesLimited investigationFinal reportPiper PA-18-135 · Myrtle Beach, SCthe pilot-in-command's failure to maintain directional control after landing.Mar 30, 1998 · N2150A · Substantial damageNTSB LAX98LA130Accident · Minor injuriesLimited investigationFinal reportCessna 150A · Apple Valley, CAThe pilot's selection of an unsuitable landing area.Mar 30, 1998 · N6640T · Substantial damageNTSB IAD98LA041Accident · No injuriesLimited investigationFinal reportCessna 152 · Windsor Locks, CTThe student pilot's inattention during taxi, which resulted in the collision with a fuel truck.Mar 30, 1998 · N5357H · Substantial damageNTSB 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.Mar 30, 1998 · N4769C · Substantial damageNTSB 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.Mar 30, 1998 · N158EH · Substantial damageNTSB NYC98LA082Accident · No injuriesLimited investigationFinal reportCessna 172P · Plainville, CTThe pilot's inadequate crosswind compensation.Mar 29, 1998 · N9821L · Substantial damageNTSB 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.Mar 29, 1998 · N101DT · 2 aircraft · Substantial damageNTSB 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…Mar 29, 1998 · N22358 · Substantial damageNTSB ATL98LA061Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Hampton, GAThe pilot's failure to maintain directional control during a full stop landing roll.Mar 29, 1998 · N1846A · Substantial damageNTSB NYC98LA084Accident · No injuriesLimited investigationFinal reportCessna 140 · Linden, NJThe pilot in commands improper recovery from a bounced landing.Mar 28, 1998 · N2229V · Substantial damageNTSB MIA98FAMS2Accident · 1 fatalMissing aircraftFinal reportCessna 182H · MissingUndetermined.Mar 28, 1998 · N8460S · DestroyedNTSB 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.Mar 28, 1998 · N31699 · Substantial damageNTSB 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…Mar 28, 1998 · N83LE · Substantial damageNTSB 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.Mar 28, 1998 · N617Y · DestroyedNTSB 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…Mar 28, 1998 · N9140C · Substantial damageNTSB 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.Mar 27, 1998 · N31226 · Substantial damageNTSB NYC98LA083Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Milford Center, OHthe pilot's excessive application of brakes during an aborted takeoff roll.Mar 27, 1998 · N1998N · Substantial damageNTSB 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.Mar 27, 1998 · N192ER · Substantial damageNTSB 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.Mar 26, 1998 · N3719J · Substantial damageNTSB 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.Mar 26, 1998 · N22LD · DestroyedNTSB 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…Mar 26, 1998 · N2952J · Substantial damageNTSB 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.Mar 26, 1998 · N5530M · Substantial damageNTSB 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 landingMar 26, 1998 · N173VE · DestroyedNTSB 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.Mar 26, 1998 · N3700G · Substantial damageNTSB 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.Mar 25, 1998 · N3751F · Substantial damageNTSB 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…Mar 25, 1998 · N4010X · Substantial damageNTSB 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.Mar 25, 1998 · N6720K · Substantial damageNTSB 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.Mar 25, 1998 · N2044N · Substantial damageNTSB FTW98IA158Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-10-10 · Denver, COThe total failure of one main landing gear tire.Mar 25, 1998 · N1836U · Minor damageNTSB 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.Mar 25, 1998 · N7339T · DestroyedNTSB 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.Mar 24, 1998 · N3MG · Substantial damageNTSB SEA98LA051Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Kalispell, MTThe pilot's failure to maintain adequate crosswind correction during landing. A factor was a crosswind.Mar 24, 1998 · N1770A · Substantial damageNTSB MIA98LA105Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Punta Gorda, FLThe total loss of engine power due to fuel starvation.Mar 24, 1998 · N8490W · Substantial damageNTSB 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…Mar 24, 1998 · N7301P · Substantial damageNTSB 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.Mar 24, 1998 · N59448 · Substantial damageNTSB 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,…Mar 24, 1998 · N73780 · Substantial damage