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 SEA96LA191Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Lander, WYthe pilot's failure to maintain directional control of the airplane during the landing roll. Factors relating to the accident were: the variable and gusty wind conditions.Aug 19, 1996 · N9542S · Substantial damageNTSB LAX96LA312Accident · No injuriesLimited investigationFinal reportRyan ST3KR · Vacaville, CAThe pilot's failure to maintain directional control of the aircraft during the landing rollout.Aug 19, 1996 · N57011 · Substantial damageNTSB LAX96LA309Accident · No injuriesLimited investigationFinal reportCessna 195A · San Luis Obispo, CAthe pilot's failure to maintain directional control, which resulted in a ground loop/swerve.Aug 19, 1996 · N4478C · Substantial damageNTSB FTW96LA351Accident · Serious injuriesLimited investigationFinal reportCessna A185F · Midland, TXfailure of the pilot to obtain or maintain adequate airspeed, by allowing the airplane to enter an excessive nose high attitude and an excessive rate of climb after takeoff, which resulted in an inadvertent stall and subsequent collision with the terrain. A…Aug 19, 1996 · N61609 · Substantial damageNTSB CHI96TA306Accident · Minor injuriesFinal reportHughes 269A · Cedar Rapids, IApartial blocking of the fuel injection control, and a fracture of the induction air ducting for reasons undetermined. A factor was trees.Aug 19, 1996 · N7052A · Substantial damageNTSB CHI96LA307Accident · No injuriesLimited investigationFinal reportCessna 180 · Duxbury, MNthe failure of the pilot to maintain airspeed.Aug 19, 1996 · N2814A · Substantial damageNTSB CHI96FA309Accident · Serious injuriesField investigationFinal reportPiper PA-32-300 · Crystal Lake, ILthe pilot's inadequate fuel management and which resulted in fuel system exhaustion. The factors involved were the pilot's failure to refuel, inadequate preflight planning/preparation and the dark night conditions encountered.Aug 19, 1996 · N823PJ · DestroyedNTSB CHI96FA301Accident · 2 fatalField investigationFinal reportBellanca 7GCAA · Hinckley, ILthe instructor pilot exceeded the design stress limits of the aircraft which resulted in the overload failure of the wing. A factor was that the weight and balance of the aircraft was exceeded by the instructor pilot.Aug 19, 1996 · N5026Q · DestroyedNTSB SEA96LA195Accident · No injuriesLimited investigationFinal reportCessna 182E · Grangeville, IDfailure of the pilot to maintain proper runway alignment and clearance from a fence post during landing. Factors relating to the accident were: an animal (deer) on the approach end of the runway, an encounter with a downdraft, and a fence post near the edge…Aug 18, 1996 · N3270Y · Substantial damageNTSB SEA96LA194Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Mulino, ORloss of engine power for undetermined reason(s).Aug 18, 1996 · N150KS · Substantial damageNTSB IAD96LA137Accident · Serious injuriesLimited investigationFinal reportBellanca 8KCAB · Waterford, OHthe pilot's decision to abruptly maneuver the airplane with insufficient altitude to recover.Aug 18, 1996 · N88428 · Substantial damageNTSB FTW96LA354Accident · Minor injuriesLimited investigationFinal reportCessna 170B · Victoria, TXthe pilot's failure to maintain directional control of the airplane during the landing roll. A related factor was the rough/uneven terrain (gopher mound) on the grass runway.Aug 18, 1996 · N600JM · Substantial damageNTSB FTW96LA350Accident · Minor injuriesLimited investigationFinal reportHardy Quickie Q-200 · Hudson, COdelamination of a propeller blade. A factor relating to the accident was: the terrain condition in the emergency landing area (soft/sandy berm and ditch).Aug 18, 1996 · N6NH · Substantial damageNTSB CHI96LA305Accident · No injuriesLimited investigationFinal reportTaylorcraft 19 · Shakopee, MNfailure of the right main landing gear shock strut due to internal corrosion. The restriction to inspection of the strut was a related factor.Aug 18, 1996 · N6630N · Substantial damageNTSB ATL96LA121Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Tuscaloosa, ALThe pilot's failure to see and avoid an antenna during low altitude maneuvering.Aug 18, 1996 · N4405E · Substantial damageNTSB ANC96LA128Accident · No injuriesLimited investigationFinal reportChampion 7GCBC · Kenai, AKthe pilot's delayed in initiating a go-around, and his failure to maintain clearance from trees. The high/fast approach for landing was a related factor.Aug 18, 1996 · N5267X · Substantial damageNTSB ANC96LA127Accident · No injuriesLimited investigationFinal reportCessna 170B · Cantwell, AKA failure of the pilot to provide sufficient takeoff distance from the edge of the departure lake and his premature liftoff.Aug 18, 1996 · N3546C · Substantial damageNTSB NYC96LA170Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-1B · Tafton, PAThe pilot's misjudgment of speed and distance during the landing.Aug 17, 1996 · N9611L · Substantial damageNTSB LAX96LA311Accident · No injuriesLimited investigationFinal reportAtkinson Varieze · Glendale, AZThe fracture and separation of the mixture control cable housing from the carburetor mounting bracket, which resulted in fuel starvation due to an overlean condition, and the pilot's failure to maintain an adequate airspeed while stretching the glide to the…Aug 17, 1996 · N3LV · Substantial damageNTSB LAX96FA308Accident · 1 fatalField investigationFinal reportCessna 210E · Big Bear City, CAan inadequate annual inspection conducted by other maintenance personnel.Aug 17, 1996 · N4931U · DestroyedNTSB FTW96LA364Accident · No injuriesLimited investigationFinal reportCessna 152 · Spring, TXfailure of the pilot to maintain directional control of the airplane during a touch-and-go, which resulted in an inadvertent ground swerve, an encounter with soft terrain, and a nose over of the airplane.Aug 17, 1996 · N89032 · Substantial damageNTSB FTW96LA349Accident · 1 fatalLimited investigationFinal reportAyres S2R-T34 · W. Helena, ARThe inadequate visual lookout of the vehicle driver and his inadvertent driving of the vehicle onto the runway resulting in the pilot of the departing aircraft performing an evasive maneuver in an attempt to avoid the collision.Aug 17, 1996 · N3095X · DestroyedNTSB CHI96LA304Accident · No injuriesLimited investigationFinal reportCessna 150M · Traverse City, MIthe failure of the pilot of the Cessna 180, N2406C, to maintaining proper spacing from the Cessna 150M, N9352U. A factor relating to this accident was the Cessna 180 pilot's diverted attention.Aug 17, 1996 · N9352U · 2 aircraft · Substantial damageNTSB CHI96LA302Accident · No injuriesLimited investigationFinal reportCessna 172 · Greenwood, ILthe pilot's failure to obtain a proper touchdown point.Aug 17, 1996 · N6218F · Substantial damageNTSB ATL96LA120Accident · No injuriesLimited investigationFinal reportGreat Lakes GL2T-1A-2 · Montgomery, ALThe locked rudder in a fully deflected position which resulted in the pilot's inability to maintain directional control.Aug 17, 1996 · N47L · Substantial damageNTSB ATL96FA119Accident · 1 fatalField investigationFinal reportCessna 172H · St. Petersburg, FLAn engine malfunction for undetermined reasons. A factor was the pilot's selection of an unsuitable landing site.Aug 17, 1996 · N8016L · Substantial damageNTSB ANC96LA132Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Dillingham, AKThe pilot's selection of unsuitable terrain for landing. Soft terrain was a factor in the accidentAug 17, 1996 · N6119W · Substantial damageNTSB NYC96IA169Incident · No injuriesIncident investigationFinal reportBoeing 727-232 · Howard Beach, NYfatigue failure of the fore flap attachment fitting, due to grinding marks on the fitting.Aug 16, 1996 · N24343 · Minor damageNTSB MIA96LA214Accident · No injuriesLimited investigationFinal reportCessna 150F · Plant City, FLa loss of engine power due to fuel contamination, resulting in a forced landing, and subsequent nose over. A factor in this accident was an inadequate aircraft pre-flightAug 16, 1996 · N7053F · Substantial damageNTSB FTW96LA348Accident · Minor injuriesLimited investigationFinal reportVans RV-4 · Van Horn, TXloss of engine power due to a cracked oil cooler, which led to the loss of all lubricating oil and an engine seizure. The lack of suitable terrain for a forced landing was a related factor.Aug 16, 1996 · XBINF · Substantial damageNTSB FTW96LA347Accident · No injuriesLimited investigationFinal reportCessna 150H · Fort Collins, COimproper flare by the pilot, which resulted in a hard landing, and subsequent overload failure of the nosewheel axle and nose gear.Aug 16, 1996 · N6935S · Substantial damageNTSB CHI96LA300Accident · Serious injuriesLimited investigationFinal reportCessna 188 · Walnut Grove, MNthe pilot's failure to maintain proper clearance from the transmission wire.Aug 16, 1996 · N2081J · Substantial damageNTSB CHI96LA299Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Portland, INthe aircraft ground looped when the pilot lost control of the aircraft during landing.Aug 16, 1996 · N2309A · Substantial damageNTSB ANC96LA129Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Slana, AKThe pilot's failure to maintain directional control during takeoff. A factor associated with the accident was the rough and uneven terrain.Aug 16, 1996 · N6760B · Substantial damageNTSB ANC96LA125Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Anchorage, AKthe pilot's misjudgment of distance and altitude to the runway during the approach, and failure to attain the proper touchdown point. A factor relating to the accident was: the ditch.Aug 16, 1996 · N9272D · Substantial damageNTSB SEA96LA208Accident · No injuriesLimited investigationFinal reportCessna 150M · Paterson, WAfailure of the student pilot to maintain directional control of the airplane during a landing, which resulted in an uncontrolled ground loop/swerve. Factors relating to the accident were: the gusty crosswind condition, and soft terrain beside the runway.Aug 15, 1996 · N3882V · Substantial damageNTSB SEA96LA193Accident · No injuriesLimited investigationFinal reportCessna A185E · Cody, WYfailure of the pilot to maintain directional control of the airplane and runway alignment during the takeoff roll. Factors relating to the accident were: the crosswind, and possible dragging of the right brake.Aug 15, 1996 · N185K · Substantial damageNTSB MIA96WA230Accident · 8 fatalForeign investigationBell UH-1B · Concepcion, ArgentinaAug 15, 1996 · LVWAV · DestroyedNTSB MIA96LA213Accident · No injuriesLimited investigationFinal reportCessna 152 · Lantana, FLthe pilot misjudged the flare, resulting in a hard landing, and the nose gear collapsing.Aug 15, 1996 · N89405 · Substantial damageNTSB IAD96LA135Accident · No injuriesLimited investigationFinal reportMooney M20F · Hanover, PAthe pilot's delay in aborting the landing. Factors related to the accident were: the lack of braking action on the wet grass runway, the pilot's lack of experience in the make and model of airplane, and the sign near the departure end of the runway.Aug 15, 1996 · N9103V · Substantial damageNTSB IAD96FA136Accident · 2 fatalField investigationFinal reportBellanca 8KCAB · Elkton, MDThe pilot's failure to maintain adequate altitude and control of the airplane while performing aerobatic maneuvers.Aug 15, 1996 · N2535Z · DestroyedNTSB CHI96LA298Accident · No injuriesLimited investigationFinal reportPiper PA-38 · Fairbury, NEinadequate airspeed and an inadvertant stall during the initial takeoff climb. Factors associated with the accident were the rough terrain used for takeoff and the ditch at the departure end on the field.Aug 15, 1996 · N2538N · Substantial damageNTSB CHI96LA295Accident · Minor injuriesLimited investigationFinal reportBeech V35 · Custer, SDloss of engine power for undetermined reason(s). The terrain condition beyond the end of the runway was a related factor.Aug 15, 1996 · N2055V · DestroyedNTSB NYC96IA168Incident · No injuriesIncident investigationFinal reportBoeing 727-232 · Flushing, NYa failure of the low pressure turbine assembly for undetermined reason(s).Aug 14, 1996 · N533DA · No damageNTSB LAX96LA306Accident · Minor injuriesLimited investigationFinal reportCessna 172Q · Kayenta, AZthe pilot's failure to adhere to the manufacturer's performance data by not maintaining the recommended best rate of climb speed, resulting in an inadvertent stall/mush event. The high density altitude was a related factor.Aug 14, 1996 · N65963 · Substantial damageNTSB IAD96LA133Accident · No injuriesLimited investigationFinal reportPiper PA-31T · Pottstown, PAThe pilot's failure to maintain directional control during takeoff/ground run resulting in in-flight collision with a fence. Related factors were the pilot's poor planning/decision making, and the fog.Aug 14, 1996 · N163SA · Substantial damageNTSB CHI96LA297Accident · No injuriesLimited investigationFinal reportCessna 150 · Columbia, MOthe improper recovery from a bounced landing by the pilot in command. Factors were the gusty wind conditions, and the failure of the pilot to maintain aircraft control.Aug 14, 1996 · N10645 · Substantial damageNTSB CHI96LA296Accident · No injuriesLimited investigationFinal reportCessna 150 · Olathe, KSimproper planning/decision by the pilot, which resulted in fuel exhaustion, due to an inadequate supply of fuel.Aug 14, 1996 · N61094 · Substantial damageNTSB CHI96LA294Accident · Serious injuriesLimited investigationFinal reportCameron CIGPACK-80 · Columbia, MOfailure of the pilot to see-and-avoid transmission (power) lines during the landing. Factors relating to the accident were: vegetation and trees, which obscured the pilot's view of the power lines.Aug 14, 1996 · N4535W · Substantial damageNTSB ANC96LA124Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Skwentna, AKAn engine failure due to an eroded engine piston. Factors in the accident were unsuitable terrain for a forced landing and improperly timed magnetos.Aug 14, 1996 · N7797B · Substantial damage