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 BFO90LA010Accident · No injuriesLimited investigationFinal reportCessna 152 · Front Royal, VAFailure of the instructor pilot (CFI) to maintain proper runway alignment with the runway. Contributing factors were: the student pilot's high and fast approach, the cfi's delay in initiating remedial action, the crosswind, and the runwaylight.NTSB ATL90LA027Accident · Minor injuriesLimited investigationFinal reportPiper PA-32R-300 · Morrisville, NCLoss of engine power for an unknown reason. The dark night and instrument conditions contributed to the accident.NTSB SEA90LA015Accident · No injuriesLimited investigationFinal reportCessna 182P · Hillsboro, ORFailure of the pilot to attain the proper touchdown point or go around while there was still sufficient runway and speed remaining. The tailwind was a related factor.NTSB LAX90LA030Accident · Minor injuriesLimited investigationFinal reportCessna 210 · North Hollywood, CAImproper planning/decision by the pilot, which resulted in fuel exhaustion from an inadequate supply of fuel. Factors related to the accident were: false fuel gage indications, lack of a suitable area for a forced landing, and obstructions (utility pole &…NTSB LAX90FA031Accident · 1 fatalField investigationFinal reportPiper PA-28R-200 · Camarillo, CAImproper IFR procedure by the pilot, and his failure to maintain the minimum descent altitude (mda) for that segment of the VOR approach. Factors related to the accident were: darkness, low ceiling, fog, haze, the pilot's lack of recent instrument experience,…NTSB DEN90LA023Accident · Serious injuriesLimited investigationFinal reportCessna 172P · Bryce Canyon, UTThe pilot's failure to attain adequate climb speed. Contributing factors were: inadequate preflight planning in that the pilot did not adequately consider the high density altitude effect on the airplane's climb performance.NTSB ATL90LA026Accident · No injuriesLimited investigationFinal reportLearjet 24 · Atlanta, GAThe pilot in command's failure to insure his airplane was clear of a parked aircraft while maneuvering to park.NTSB SEA90LA013Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Hillsboro, ORFuel contamination and the pilots lack of peflight inspection. Contributing to the accident was the soft terrain.NTSB NYC90LA028Accident · No injuriesLimited investigationFinal reportCessna 205 · Morristown, NJIn-flight collision with object.NTSB NYC90LA026Accident · No injuriesLimited investigationFinal reportBeech A24R · Bridgeport, CTThe airplane engine throttle cable failed and the engine power reduced to idle over long island sound, resulting in the ditching of the airplane.NTSB BFO90LA021Accident · No injuriesLimited investigationFinal reportSchweizer SGS-1-35C · Paint Bank, VAThe pilot's improper inflight planning which led to an off-airport landing after encountering deteriorating lift conditions. Contributing factors were the mountainous terrain and lack of a suitable landing area.NTSB NYC90LA027Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Coatesville, PAImproper planning/decision by the pilot which resulted in fuel exhaustion due to an inadequate supply of fuel.NTSB MKC90LA028Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Pine Bluff, ARAn inadequate preflight which resulted in water contamination in the fuel system and the subsequent loss of power.NTSB MKC90LA027Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Springdale, ARThe banner tow pick up equipment became entangled resulting in a jammed rudder and restricted aircraft control.NTSB MKC90FA026Accident · Serious injuriesField investigationFinal reportCessna T210 · Columbia, MOAn engine compartment fire due to a missing turbocharger exhaust duct and tailpipe assembly. The clamp used to retain the tailpipe assembly to the turbocharger was also missing, contributing factor(s) was: the soft terrain.NTSB FTW90LA026Accident · No injuriesLimited investigationFinal reportCessna 172K · Fabens, TXThe pilot's improper flare during landing and inadequate recovery from the ensuing bounced landing. The unfavorable wind was a related factor.NTSB FTW90LA025Accident · No injuriesLimited investigationFinal reportBeech 95 · Floydada, TXFailure of the propeller attachment bolts due to fatigue in four of the bolts and overload in another. A contributing factor was the loss of electrical power and the deteriorated airplane control/preformance.NTSB CHI90LA025Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Mcleansboro, ILThe pilot-in-command's failure to maintain control of the aircraft while recovering from a bounced landing.NTSB BFO90LA015Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Ocean City, NJFailure of the pilot to obtain proper assistance or properly secure (tie down/chock) the aircraft.NTSB SEA90LA012Accident · No injuriesLimited investigationFinal reportMcCulloch J-2 · Scappoose, ORDelayed remedial action by the flight instructor and failure of the student to relinguish control. Factors include inadequate airspeed and an excessive descent rate.NTSB MKC90LA029Accident · No injuriesLimited investigationFinal reportCessna 152 · Cape Girardeau, MOPoor planning by the pilot in not refueling enroute which resulted in fuel exhaustion.NTSB MKC90LA025Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Hays, KSThe pilot's failure to properly flare the airplane during landing.NTSB LAX90LA053Accident · No injuriesLimited investigationFinal reportCessna 177 · Tucson, AZImproper flare by the student pilot, which resulted in a porpoise, and his improper recovery from a bounced landing.NTSB LAX90LA029Accident · No injuriesLimited investigationFinal reportBell-Kitz Kopters 47D1 · Chino, CAA fatigue failure of both the main rotor stabilizer bar tube and the tie rod. In addition, the tie rod nut was loose and did not conform to engineering drawing specifications. Company personnel failed to detect the fatigue cracks during daily inspections.NTSB DEN90FA022Accident · Serious injuriesField investigationFinal reportCessna 182F · Oakley, UTThe pilot diverted his attention, misjudged his altitude and failed to maintain clearance above the trees, while maneuvering at low altitude over mountainous terrain. The mountainous terrain, high density altitude, low airspeed, and trees were contributing…NTSB BFO90LA009Accident · No injuriesLimited investigationFinal reportBeech C33 · Richmond, VACracked fuel flow indicator fuel line which allowed fuel to come in contact with electrical components of the instrument panel which resulted in a fire.NTSB SEA90LA014Accident · No injuriesLimited investigationFinal reportCessna 182E · Quilcene, WAThe pilot failed to adequately compensate for tailwind conditions when landing on a short wet runway.NTSB MKC90LA024Accident · Serious injuriesLimited investigationFinal reportMcdonnell Douglas 369HS · Oklee, MNAn undetermined power plant failure. Factors related to the accident were: the snow covered terrain, snow, and gusty wind.NTSB LAX90FA027Accident · 2 fatalField investigationFinal reportCessna R182 · San Diego, CAThe pilot's continued VFR flight into instrument meteorological conditions (IMC), and his failure to maintain aircraft control after becoming spatially disoriented. Factors in the acident were: darkness, adverse weather conditions, and the pilot's lack of…NTSB DEN90LA020Accident · Minor injuriesLimited investigationFinal reportBeech V35B · Broomfield, COLoss of engine power for an unknown reason.NTSB DEN90FA021Accident · 2 fatalField investigationFinal reportCessna 310I · Provo, UTThe Cessna pilot misjudge his altitude above the water. Contributing factors were: the pilot allowing his attention to be diverted and his lack of visual/depth perception over the calm (glassy) water.NTSB CHI90LA024Accident · No injuriesLimited investigationFinal reportBeech A36 · Angola, INFailure of the pilot to follow IFR procedures and maintain the minimum descent altitude (mda). Factors related to the accident were: darkness and adverse weather conditions.NTSB SEA90FA133Accident · 1 fatalField investigationFinal reportCessna 172M · Snoqualmie, WAIntentional flight into known adverse weather conditions and poor weather evaluation by the pilot.NTSB LAX90LA028Accident · No injuriesLimited investigationFinal reportPiper PA38-112 · Chandler, AZThe pilot failed to properly use the checklist and the fuel selector valve was improperly selected to the empty tank.NTSB DEN90TL#01Accident · Serious injuriesClass 3Final reportPiper PA-18-150 · Alamagordo, NMNTSB DEN90LA019Accident · No injuriesLimited investigationFinal reportUniversal Stinson 108-3 · Fort Collins, COInadequate compensation for wind conditons by the pilot which resulted in his failure to maintain directional control. Factors related to the accident were: the unfavorable wind condition and soft terrain.NTSB CHI90LA023Accident · No injuriesLimited investigationFinal reportPiper 601P · Cincinnati, OHThe pilot failed to maintain adequate airspeed while maneuvering to circle and land, which resulted in an inadvertent stall. Factors related to the accident were: the excessive maneuver (steep turn) and terrain conditions (road and curb) short of the runway.NTSB MKC90LA030Accident · No injuriesLimited investigationFinal reportAir Tractor AT301 · Ellinwood, KSThe partial failure of the engine for undetermined reasons which resulted in a forced landing. A factor related to the accident was the soft dirt.NTSB MKC90LA022Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Toledo, IAThe pilot became lost/disorientated and attempted a landing at the wrong airport. Factors related to the accident were: darkness, unfavorable wind condition, and the student pilot's lack of experience in the type of operation.NTSB LAX90LA026Accident · No injuriesLimited investigationFinal reportPiper PA-38 · Chino, CALoss of engine power for an undetermined reason. Soft terrain in the emergency landing area was a related factor.NTSB DEN90LA018Accident · No injuriesLimited investigationFinal reportCessna U206B · Billings, MTImproper planning/decision by the pilot while taxiing during unfavorable wind conditions.NTSB ANC90LA012Accident · No injuriesLimited investigationFinal reportCessna 207 · Quinhagak, AKFatigue failure of the right rudder bar. A factor related to the accident was: rough/uneven terrain beside the runway.NTSB ANC90LA011Accident · No injuriesLimited investigationFinal reportCessna 150 · Birchwood, AKFailure of the pilot to maintain proper runway alignment during the takeoff roll. Related factors were: dark night, snow covered runway, inadequate snow removal from the runway by personnel (who were responsible for snow removal), and the snowbank (berm).NTSB ANC90LA009Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Kenai, AKFailure of the engine bearing, which resulted in a subsequent total loss of power. Contributing factors were: dark night and rough/uneven terrain.NTSB ANC90FA010Accident · No injuriesField investigationFinal reportCessna A185E · Anchorage, AKThe throttle control linkage became disconnected on the first flight after an annual inspection due to improper maintenance. Darkness and high vegetation were contributing factors.NTSB LAX90LA024Accident · No injuriesLimited investigationFinal reportCessna 320 · Hayward, CAFailure of the pilot to attain the proper touchdown point and his improper flare for landing. Factors related to the accident were: the pilot's lack of experience in the make and model of aircraft, and company induced pressure.NTSB LAX90LA022Accident · No injuriesLimited investigationFinal reportBeech D17S · Flagstaff, AZAn inadvertent gear-up landing by the pilot. A contributing factor was the pilot's acceptance of a visual gear-up warning as normal since it is on all the time.NTSB LAX90LA021Accident · Serious injuriesLimited investigationFinal reportBoeing 757-2S7 · Phoenix, AZThe ground handler improperly crossing under the aircraft while it was moving.NTSB LAX90FA025Accident · 2 fatalField investigationFinal reportCessna 172 · Safford, AZThe pilot failed to maintain an airspeed above the aircraft's stall speed as he turned away from ascending terrain. The aircraft's inadequate performance resulting from improper grade of fuel and high density altitude and the pilot's lack of experience in…NTSB ATL90DKG02Accident · 1 fatalFinal reportBell 47G/Tomcat MK5 · Elberton, GAA loss of engine power due to carburetor ice.