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 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB CHI89DEE05Accident · No injuriesFinal reportCessna 152 · Romeoville, ILThe pilot's misjudgement of the fuel supply.NTSB 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…NTSB 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.NTSB 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.NTSB MKC89IA168Incident · No injuriesIncident investigationFinal reportBeech 65-90 · Springdale, ARThe pilot's failure to extend the landing gear.NTSB 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.NTSB 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.NTSB 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.NTSB 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…NTSB 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.NTSB 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.NTSB 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…NTSB 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.NTSB LAX89DUG06Accident · No injuriesFinal reportBoeing A75N1 · Chino, CAThe pilot losing directional control after a hard landing, which resulted in a nose over.NTSB 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.NTSB 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.NTSB 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.NTSB NYC89LA175Accident · No injuriesLimited investigationFinal reportCessna 170B · Bricktown, NJUndetermined. The terrain was a related factor.NTSB 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.NTSB DEN89FA178Accident · Serious injuriesField investigationFinal reportBeech E35 · Kalispell, MTContaminated fuel system that starved the engine of fuel.NTSB 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…NTSB 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…NTSB 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.NTSB 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.NTSB 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.NTSB MKC89LA166Accident · Minor injuriesLimited investigationFinal reportCessna T210 · Hannibal, MOFuel starvation for undetermined reasons which resulted in a forced landing and subsequent collision with trees.NTSB 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.NTSB 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.NTSB 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).NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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…NTSB 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.NTSB SEA89FA139Accident · 2 fatalField investigationFinal reportStinson 108-2 · Athol, IDThe pilot failed to maintain airspeed and inadvertently stalled.NTSB MKC89LA167Accident · No injuriesLimited investigationFinal reportCessna 320 · St. Clair, MOThe landing gear retraction/extention system failed for undetermined reason.NTSB LAX89LA243Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · Van Nuys, CAA loss of engine power for undetermined reasons.NTSB 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.NTSB 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.NTSB 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…NTSB ATL89DKJ07Accident · 1 fatalFinal reportCessna A188B · Town Creek, ALThe inadvertent stall at an altitude inadequate to effect a safe recovery.NTSB MIA89LA204Accident · No injuriesLimited investigationFinal reportTexas Helicopter OH-13E/M74 · Greenwood, MSFailure of a main rotor blade pitch change horn and/or attaching bolt(s).NTSB 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…