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 LAX89LA257Accident · Minor injuriesLimited investigationFinal reportCessna 337H · Honolulu, HIAn unexpected and sudden encounter with severe turbulence while the aircraft was cruising over the pacific ocean in cumulus cloud conditions.Jul 27, 1989 · N2AC · Substantial damageNTSB LAX89LA250Accident · No injuriesLimited investigationFinal reportCessna 210 · Thermal, CAA twisted nose gear uplock due to an elongated bolt hole which prevented the nose gear from extending.Jul 27, 1989 · N76RR · Substantial damageNTSB CHI89LA149Accident · No injuriesLimited investigationFinal reportCessna 172M · Wixom, MICarburetor ice due to the pilot's improper use of carburetor heat. Factors related to the accident were: weather conditions conducive to carburetor ice, dark night, and tree(s) in the emergency landing area.Jul 27, 1989 · N12662 · Substantial damageNTSB CHI89LA148Accident · No injuriesLimited investigationFinal reportGrumman AA-1C · Madison, INThe student's failure to maintain directional control of the aircraft and the cfi's delay in taking remedial action to regain control. Contributing to the accident was the students lack of total experience.Jul 27, 1989 · N39035 · Substantial damageNTSB CHI89LA147Accident · 1 fatalLimited investigationFinal reportPiper PA-38-112 · River Falls, WIImproper remedial action by the pilot following an abrupt maneuver. The pilot's lack of total aviation experience was a factor in the accident.Jul 27, 1989 · N25687 · DestroyedNTSB CHI89LA146Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Nappanee, INThe pilot-in-command's improper preflight calculation of weight and balance and the aircraft's inadequate climb capability due to low compression.Jul 27, 1989 · N3923F · Substantial damageNTSB CHI89DEE05Accident · No injuriesFinal reportCessna 152 · Romeoville, ILThe pilot's misjudgement of the fuel supply.Jul 27, 1989 · N25848 · Substantial damageNTSB ATL89LA185Accident · No injuriesLimited investigationFinal reportCessna 172K · Wilmington, NCThe inadequate preflight preparation/planning by the pilot regarding the unique light features on runway 18 (lights mounted along the east side only). In addition the pilot failed to align the airplane with the runway and struck a vehicle that was parked…Jul 27, 1989 · N7444G · Substantial damageNTSB ANC89LA129Accident · Minor injuriesLimited investigationFinal reportCessna 206G · Iliamna, AKImproper planning/decision by the pilot & his failure to attain adequate speed to fly. The terrain (bank) was a contributing factor.Jul 27, 1989 · N6588Z · Substantial damageNTSB NYC89IA176Incident · No injuriesIncident investigationFinal reportDouglas DC-9-30 · Newark, NJRupture of a flexible high pressure hydraulic line in the 'a' hydraulic system, due to chafing of the steel braid covering, which allowed the system pressure and quantity to be completely depleted.Jul 26, 1989 · N556NY · Minor damageNTSB MKC89IA168Incident · No injuriesIncident investigationFinal reportBeech 65-90 · Springdale, ARThe pilot's failure to extend the landing gear.Jul 26, 1989 · N195DP · Minor damageNTSB LAX89LA248Accident · Serious injuriesLimited investigationFinal reportFlug-Und Fahrzeugwerke Diament 16.5 · Marana, AZThe loss of aircraft control resulting from an uncommanded upward pitch shortly after lift off.Jul 26, 1989 · N808VV · DestroyedNTSB LAX89LA247Accident · Serious injuriesLimited investigationFinal reportPiper PA-22 · Placerville, CAThe improper maintenance performed at the last overhaul which resulted in the failure of the #3 main bearing. Contributing to the accident was the lack of a suitable landing area for the emergency landing.Jul 26, 1989 · N5925D · DestroyedNTSB ATL89DKJ08Accident · Serious injuriesFinal reportCessna A188B · Atmore, ALPilot's failure to maintain visual lookout for obstacles. Contributing to the accident was the low (dawn) position of the sun which interfered with the pilot's vision.Jul 26, 1989 · N21612 · Substantial damageNTSB NYC89LA174Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-161 · Stonington, CTThe pilot's inadvertent flight into instrument meteorological conditions (IMC) and his loss of aircraft control due to spatial disorientation. Factors related to the accident were: the environmental conditions (dark night & fog) and the pilot's lack of…Jul 25, 1989 · N29216 · DestroyedNTSB MKC89LA169Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Harviell, MOThe pilot's inability to avoid unsuitable terrain during the landing roll after a forced landing. The forced landing was made necessary by a loss of engine power caused by a foreign object restricting the fuel system.Jul 25, 1989 · N48426 · Substantial damageNTSB MIA89LA207Accident · No injuriesLimited investigationFinal reportCessna 172N · Gainesville, FLThe student's improper flare for landing. The crosswind (quartering headwind) and the student's lack of experience in this aircraft were considered to be contributing factors.Jul 25, 1989 · N5186J · Substantial damageNTSB LAX89LA246Accident · Serious injuriesLimited investigationFinal reportHughes 269C · Kalapana, HIThe loss of engine power due to the failure of the engine exhaust valve in the no. 2 cylinder and the disregard of the Lycoming service bulletin by company maintenance personnel. Contributing to the accident was the high vegetation and trees located at the…Jul 25, 1989 · N58344 · Substantial damageNTSB LAX89DVD04Accident · Minor injuriesFinal reportTravel Air 4000 · Lodi, CAThe failure of the pilot to see and avoid power lines, while distracted by a moving vehicle on the ground.Jul 25, 1989 · N1592 · DestroyedNTSB LAX89DUG06Accident · No injuriesFinal reportBoeing A75N1 · Chino, CAThe pilot losing directional control after a hard landing, which resulted in a nose over.Jul 25, 1989 · N68491 · Substantial damageNTSB DEN89LA179Accident · No injuriesLimited investigationFinal reportPiper PA-18-135 · Boulder, COFailure of the pilot to maintain directional control, which resulted in an inadvertent ground swerve and subsequent damage to the wing.Jul 25, 1989 · N9967Q · Substantial damageNTSB DEN89DQA02Accident · 1 fatalFinal reportCloud MA-5 Charger · Vaughn, NMThe pilot's failure to maintain adequate airspeed which resulted in the aircraft entering a stall/mush at too low an altitude to permit recovery. Contributing to the accident was the high density altitude.Jul 25, 1989 · N3137G · DestroyedNTSB SEA89LA140Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Vashon, WAThe pilot's inadequate preflight planning/preparation. Factors related to the accident were: unfavorable wind conditions, high obstructions (trees), and soft terrain where the aircraft touched down during the aborted takeoff.Jul 24, 1989 · N8402C · Substantial damageNTSB NYC89LA175Accident · No injuriesLimited investigationFinal reportCessna 170B · Bricktown, NJUndetermined. The terrain was a related factor.Jul 24, 1989 · N8388A · Substantial damageNTSB LAX89LA244Accident · No injuriesLimited investigationFinal reportBeech BE58 · Sedona, AZThe pilot improperly leaning the fuel mixture of the left engine and the delay in aborting the takeoff. A contributing factor was the high density altitude conditions.Jul 24, 1989 · N7454N · Substantial damageNTSB DEN89FA178Accident · Serious injuriesField investigationFinal reportBeech E35 · Kalispell, MTContaminated fuel system that starved the engine of fuel.Jul 24, 1989 · N3317C · Substantial damageNTSB DEN89FA177Accident · 1 fatalField investigationFinal reportCessna 152 · Logan, UTInadequate preflight and improper inflight planning/decision by the student, which resulted in fuel exhaustion from an inadequate supply of fuel, and the student's failure to maintain airspeed, while maneuvering, which resulted in an inadvertent stall/spin. A…Jul 24, 1989 · N46260 · Substantial damageNTSB CHI89LA164Accident · No injuriesLimited investigationFinal reportPiper PA38-112 · Milwaukee, WIStudent pilot's misjudged aircraft handling during the landing flare/touchdown, and the cfi's inadequate supervision of the operation. These resulted in an abrupt touchdown, a subsequent loss of directional control, and the aircraft's collision with the VASI…Jul 24, 1989 · N9103A · Substantial damageNTSB ANC89LA127Accident · No injuriesLimited investigationFinal reportChampion 7GCBC · Alexander Creek, AKThe pilot failed to maintain control of the aircraft during the landing flare/touchdown. Turbulence was a contributing factor.Jul 24, 1989 · N6366N · Substantial damageNTSB NYC89LA173Accident · Serious injuriesLimited investigationFinal reportSchweizer 1-23 · Eighty Four, PAPoor handling of the glider durig landing. The pilot over corrected and caused the nose to strike the runway surface. Directional control was lost, resulting in a groundloop.Jul 23, 1989 · N91867 · Substantial damageNTSB NYC89LA172Accident · Minor injuriesLimited investigationFinal reportPiper PA-18A · Atlantic City, NJThe pilot's failure to maintain adequate flying speed, and his delay to jettison the banner. A factor related to the accident was: the location of the trees.Jul 23, 1989 · N8061C · Substantial damageNTSB MKC89LA166Accident · Minor injuriesLimited investigationFinal reportCessna T210 · Hannibal, MOFuel starvation for undetermined reasons which resulted in a forced landing and subsequent collision with trees.Jul 23, 1989 · N69DM · Substantial damageNTSB MKC89LA164Accident · No injuriesLimited investigationFinal reportCessna 172 · Duluth, MNAircraft control was not maintained by the pilot in command due to improper use of the aircraft flight controls.Jul 23, 1989 · N97984 · Substantial damageNTSB MKC89FA165Accident · 2 fatalField investigationFinal reportBeech C23 · Neligh, NEFailure of the pilot to maintain adequate airspeed after intiating a steep climbing maneuver from low altitude. Factors related to the accident were: the pilot's lack of total flying experience and lack of sufficient altitude.Jul 23, 1989 · N66295 · DestroyedNTSB MIA89LA206Accident · No injuriesLimited investigationFinal reportSchweizer SGS 1-26C · Ms State Univ, MSImproper in-flight planning/decison by the pilot. Contributing factors were: failure of the tow vehicle driver to use/maintain the proper speed, the pilot's lack of total flying experience, and high vegetation (uncut hay).Jul 23, 1989 · N9944J · Substantial damageNTSB MIA89LA205Accident · No injuriesLimited investigationFinal reportMooney M22 · Vero Beach, FLFailure of an old weld repair on the nose gear strut housing. A contributing factor was improper maintenance by other (unknown) maintenance personnel.Jul 23, 1989 · N7738M · Substantial damageNTSB DEN89LA176Accident · No injuriesLimited investigationFinal reportCessna 170B · Kyle, SDThe pilot used poor preflight planning & decision-making in selecting a road on which to land during gusty wind conditions which resulted in the failure to maintain direction control.Jul 23, 1989 · N8102A · Substantial damageNTSB CHI89LA142Accident · No injuriesLimited investigationFinal reportGlobe GC-1B · Metropolis, ILPilot's failure to adhere to procedures and ensure the aircraft had sufficient airspeed before attempting rotation and climbout. Airspeed was inadequate to maintain flight, and just after the landing gear was retracted the aircraft settledto the ground.Jul 23, 1989 · N332HM · Substantial damageNTSB BFO89FA062Accident · 1 fatalField investigationFinal reportBeech 77 · Cluster Springs, VAThe pilot's failure to perform an adequate preflight which resulted in an unlatched fuel filler cap. Contributing to the accident was the pilot's failure to monitor the fuel supply during the flight.Jul 23, 1989 · N18257 · DestroyedNTSB ATL89LA184Accident · No injuriesLimited investigationFinal reportSchweizer SGS 1-26E · Alabaster, ALThe glider pilot's poor evaluation of area weather conditions during the flight, which necessitated an off-airport precautionary landing and led to a collision with rough terrain during the landing rollout. Factors contributing to the accident were the…Jul 23, 1989 · N65943 · Substantial damageNTSB ANC89LA128Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Chitina, AKThe pilot's selection of an unsuitable landing area and delay in slowing the airplane after landing. A factor in the accident was the rough/uneven terrain.Jul 23, 1989 · N7400K · Substantial damageNTSB SEA89FA139Accident · 2 fatalField investigationFinal reportStinson 108-2 · Athol, IDThe pilot failed to maintain airspeed and inadvertently stalled.Jul 22, 1989 · N8061K · DestroyedNTSB MKC89LA167Accident · No injuriesLimited investigationFinal reportCessna 320 · St. Clair, MOThe landing gear retraction/extention system failed for undetermined reason.Jul 22, 1989 · N314D · Substantial damageNTSB LAX89LA243Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · Van Nuys, CAA loss of engine power for undetermined reasons.Jul 22, 1989 · N5123S · Substantial damageNTSB CHI89LA141Accident · No injuriesLimited investigationFinal reportCessna R172K · Wisconsin Dells, WIFailure of the pilot to insure the oil filler cap was properly secured when he serviced the aircraft before takeoff, and subsequent loss of oil and oil exhaustion. The tree was considered to be a contributing factor.Jul 22, 1989 · N736DA · Substantial damageNTSB BFO89LA061Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Blacksburg, VAFailure of the pilot to maintain control of the aircraft during the landing flare/touchdown. Factors related to the accident were: adverse wind conditions and the pilot's inadequate compensation for the wind.Jul 22, 1989 · N69WP · Substantial damageNTSB ATL89LA183Accident · No injuriesLimited investigationFinal reportCessna 172P · Cincinnati, OHThe pilot's improper go-around procedure of fully retracting the flaps which resulted in the airplane mushing into trees. Contributing factor(s) was: a misjudgement of flare height above the runway and failure to remove the carburetor heat which may have…Jul 22, 1989 · N52896 · Substantial damageNTSB ATL89DKJ07Accident · 1 fatalFinal reportCessna A188B · Town Creek, ALThe inadvertent stall at an altitude inadequate to effect a safe recovery.Jul 22, 1989 · N5618G · DestroyedNTSB MIA89LA204Accident · No injuriesLimited investigationFinal reportTexas Helicopter OH-13E/M74 · Greenwood, MSFailure of a main rotor blade pitch change horn and/or attaching bolt(s).Jul 21, 1989 · N47345 · Substantial damageNTSB LAX89FA241Accident · 3 fatalField investigationFinal reportCessna 177 · Hesperia, CAAn inflight collision with a power line while maneuvering at low altitude shortly after departure on a dark night over an area with few ground reference lights. The reasons for the aircraft's flight path and altitude profile are undetermined. A factor in the…Jul 21, 1989 · N30039 · Destroyed