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 SEA94LA026Accident · 1 fatalLimited investigationFinal reportBird RAF-2000 · Redmond, UTThe pilot in command's exceeding the proper climb rate. A factor contibuting to the accident was the pilot's lack of experience in make/model.NTSB MIA94FA015Accident · 1 fatalField investigationFinal reportCessna 182Q · Crestview, FLWas incapacitation of the pilot due to cardiovascular disease during an instrument approach resulting in the aircraft descending uncontrolled until tree and ground impact. Contributing to the accident was the pilot's decision to fly with known cardiovascular…NTSB LAX94LA039Accident · No injuriesLimited investigationFinal reportBoeing PT-13D · Half Moon Bay, CAImproper planning/decision by the pilot of the second stearman, and his selection of the wrong runway on which to land. A factor related to the accident was: failure of the stearman pilots to obtain pertinent NOTAM information.NTSB LAX94LA038Accident · No injuriesLimited investigationFinal reportAerospatiale SA-341G · Lake Berryessa, CAthe pilot's selection of an inadequate obstacle clearance cruise altitude.NTSB LAX94LA037Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Sacramento, CAImproper remedial action by the student pilot. Lack of total experience is a factor.NTSB FTW94FA025Accident · 2 fatalField investigationFinal reportCessna 152 · Van Horn, TXWas the pilot's attempt to perform aerobatics at low altitude and the inadvertent stall. A factor was the pilot's ostentatious display.NTSB CHI94MA032Accident · 5 fatalMajor investigationFinal reportCessna 421B · Greensburg, INan inadvertent stall by the pilot in command. Factors associated with the accident are the icing conditions and low ceilings.NTSB BFO94LA002Accident · 1 fatalLimited investigationFinal reportFairchild SA 227-AC · Newark, NJ1) The failure of the ramp agent to follow proper procedures during the servicing of the airplane, and 2) her lack of attention to the hazards surrounding her. Factors related to the accident are 1) the pressure placed on the ramp agent to rush the servicing…NTSB LAX94LA036Accident · Minor injuriesLimited investigationFinal reportCessna 175 · Palm Springs, CAfuel exhaustion due to the pilot's failure to adequately monitor the fuel consumption during the flight.NTSB ATL94FA012Accident · 2 fatalField investigationFinal reportMooney M20L · Hohenwald, TNThe pilot's impaired judgement and performance by flying while under the influence of drugs, that resulted in his continuation of VFR flight at night in instrument meteorological conditions (IMC) and his failure to maintain proper altitude (or clearance) from…NTSB SEA94LA025Accident · No injuriesLimited investigationFinal reportCessna T210F · Sheridan, WYThe pilot did not obtain proper assistance after landing in high wing conditions. Factors contributing to the accident were the strong, gusty wind conditions.NTSB FTW94LA024Accident · No injuriesLimited investigationFinal reportBellanca BL17-31ATC · Pagosa Springs, COFailure by the pilot in command to maintain control of the aircraft during landing roll.NTSB CHI94LA031Accident · No injuriesLimited investigationFinal reportBeech B36TC · Rockford, ILA loose fuel line fitting, due to improper maintenance, which resulted in an interuption of fuel to the engine.NTSB MIA94T#A01Accident · No injuriesClass 3Final reportBell 206-BIII · Bartow, FLNTSB CHI94LA030Accident · No injuriesLimited investigationFinal reportWaco YMF-5 · Valparaiso, INThe pilot's inadequate compensation for wind conditions while landing in a gusty crosswind. Factors associated with the accident are the gusty crosswind and the pilot's lack of experience in this type airplane.NTSB ATL94FA011Accident · 5 fatalField investigationFinal reportPiper PA-32RT-300T · Wrens, GAWas the fatique failure of the idler gear which resulted in the complete loss of engine power. A factor was the dark night.NTSB ANC94LA015Accident · No injuriesLimited investigationFinal reportAeronca 7DC · Goose Bay, AKThe pilot-in-command did not maintain directional control of the airplane. A factor in the accident were the trees adjacent to the side of the runway.NTSB SEA94LA023Accident · Minor injuriesLimited investigationFinal reportCessna 172H · Mckenzie Bridge, ORA partial loss of engine power for undetermined reasons.NTSB MIA94LA014Accident · Minor injuriesLimited investigationFinal reportCessna P210N · Fort Lauderdale, FLAn engine failure for undetermined causes over terrain unsuitable for a forced landing.NTSB BFO94LA001Accident · No injuriesLimited investigationFinal reportUnivair Ercoupe 415E · Willis, VAthe failure of the airplane's throttle cable fitting due to undetermined reasons, which prevented the pilot from applying power above engine idle. A factor in this accident was the lack of suitable terrain for the pilot to complete a forced landing without…NTSB NYC94FA025Accident · 1 fatalField investigationFinal reportMooney M20K · Blue Ash, OHThe pilot's inadequate inflight decision to conduct flight into known icing conditions and his failure to maintain adequate airspeed which resulted in an inadvertent stall. Factors were icing conditions and the pilot's failure to follow the preflight briefing…NTSB LAX94LA035Accident · No injuriesLimited investigationFinal reportCessna 182P · Redding, CAthe pilot's use of an excessive airspeed on final approach, the failure to attain the proper touchdown point on the runway, and, the failure to initiate a go around when it became clear that the aircraft would excessively overshoot the intended touchdown…NTSB LAX94LA034Accident · Minor injuriesLimited investigationFinal reportSilver KR2 · Fontana, CAthe separation of an engine coolant hose which resulted in a complete loss of engine power.NTSB LAX94LA033Accident · No injuriesLimited investigationFinal reportRobinson R22A · Santa Rosa, CAthe separation of the tail rotor due to a collision with a mylar balloon and the subsequent hard landing during an autorotation. A factor in the accident was the dark night lighting conditions which limited the pilot's ability to see and avoid the balloon.NTSB SEA94LA028Accident · No injuriesLimited investigationFinal reportCessna 320C · Spirit Lake, IDThe pilot's failure to maintain airspeed. The pilot's failure to maintain directional control was a factor.NTSB SEA94LA022Accident · No injuriesLimited investigationFinal reportBeech A-35 · Billings, MTThe pilot's failure to maintain directional control during the go-around. Factors include proper airspeed not being maintained, and gusty crosswinds.NTSB MIA94WA018Accident · No injuriesForeign investigationBeech 58TC · Kingston, JamaicaNTSB LAX94LA032Accident · No injuriesLimited investigationFinal reportCessna 172N · Joshua Tree, CAthe pilot's failure to maintain a proper descent rate on final approach. A factor in the accident was the student's limited total experience.NTSB LAX94LA031Accident · No injuriesLimited investigationFinal reportCessna 170B · Prescott, AZThe pilot's loss of directional control due to his improper bounced landing recovery technique and the improper use of the rudder controls. A factor in the accident was the pilot's lack of total experience in conventional landing gear aircraft.NTSB FTW94FA023Accident · 1 fatalField investigationFinal reportBellanca 8KCAB · Saratoga, ARThe pilot-in-command's performance of aerobatics at an altitude where it was not possible to maintain clearance.NTSB ANC94LA014Accident · No injuriesLimited investigationFinal reportCessna 150 · Chignik, AKThe pilot-in-commands selection of unsuitable terrain on which to perform a takeoff. A factor in the accident was the brush.NTSB NYC94IA023Incident · No injuriesIncident investigationFinal reportBell 206L · New York, NYInadequate maintenance which resulted in the improper alignment of the 'O' ring on the spur adapter gear drive which caused lack of lubrication and wear of the gear drive and the disengagement of the compressor and turbine.NTSB MIA94LA013Accident · 3 fatalLimited investigationFinal reportBeech A36 · Ormond Beach, FLPoor judgement of the pilot, due to consumption of alcohol and use of drugs, and his failure (or inability) to maintain altitude (or clearance) above water at night. Darkness was a related factor.NTSB FTW94LA022Accident · No injuriesLimited investigationFinal reportBell 206L-3 · Gulf Of MexicoThe pilot in command's inadequate preflight inspection in that he failed to remove a tie down rope. A factor was the pilot's self-induced pressure.NTSB FTW94LA021Accident · 1 fatalLimited investigationFinal reportBell 206B · W. Cameron 240The pilot's failure to maintain proper altitude while maneuvering. Factors were his continued flight into known adverse weather and his self-induced pressure to complete the flight.NTSB ATL94FA010Accident · 1 fatalField investigationFinal reportGrumman American AA-5A · Richmond Hill, GAThe pilot's failure to maintain an adequate altitude above the water. And his physical impairment due to drugs.NTSB NYC94LA024Accident · No injuriesLimited investigationFinal reportPiper J3 · Greenland, NHThe pilot's improper landing flare which resulted in a hard landing.NTSB LAX94LA030Accident · No injuriesLimited investigationFinal reportBeech 200 · Reno, NVThe improper overhaul of the right main landing gear actuator by maintenance personnel, and the operator's failure to assure that the airplane manufacturer's mandatory service bulletin requiring modification of the gear motor circuit protection was…NTSB LAX94LA027Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Mokuleia, HIthe student pilot's misjudgement of descent rate and terrain clearance while manuevering along a ridgeline. Factors in the accident were the downdrafts and the mountainous/hilly nature of the terrain.NTSB LAX94LA026Accident · No injuriesLimited investigationFinal reportCessna 177B · Pleasant Grove, CAThe failure of the starter to turn the engine over due to inadequate maintenance and inspection.NTSB SEA94LA021Accident · Serious injuriesLimited investigationFinal reportHannah Avid Amphibian · Scappoose, ORThe pilot's poor inflight decision, and failure to maintain sufficient airspeed. Factors include contaminated fuel.NTSB SEA94LA020Accident · Serious injuriesLimited investigationFinal reportAero Commander AC-100-180 · Oregon City, ORThe pilot's failure to maintain clearance from transmission wires. Factors include light conditions at dusk, and transmission wires near the approach end of the runway.NTSB LAX94LA025Accident · 2 fatalLimited investigationFinal reportWittman Tailwind W8L · San Jose, CAThe loss of engine power for an undetermined reason(s). A factor in the accident was the unsuitable nature of the terrain encountered during the forced landing.NTSB LAX94FA028Accident · 2 fatalField investigationFinal reportPiper PA-24-250 · San Simon, AZThe pilot's improper planning/decision, and his allowing the airplane to exceed its design stress limits, which resulted in overload failure of the right outboard wind section and left horizontal stabilizer. Factors related to the accident were: the adverse…NTSB CHI94LA027Accident · No injuriesLimited investigationFinal reportCessna 170B · Maple Plain, MNThe pilot's improper compensation for wind conditions, failure to maintain runway alignment, and failure to maintain adequate airspeed during the aborted landing. Factors related to the accident were: high obstructions and the adverse wind conditions.NTSB CHI94LA026Accident · Minor injuriesLimited investigationFinal reportBeech F33A · Saint Paul, MNother maintenance personnel's improper maintenance installation and fuel system line fitting undertorqued. Factors related to the accident were the dark night, along with the fence and posts which were contacted.NTSB NYC94LA019Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Somerset, PAwas the failure of the pilot to adequately compensate for wind conditions, and maintain directional control. A factor related to the accident were the gusting crosswinds.NTSB LAX94LA029Accident · No injuriesLimited investigationFinal reportBeech 76 · Livermore, CAthe dual student's improper use of the throttle and the flight instructor's inadequate supervision of the flight.NTSB DCA94GA010Accident · 3 fatalClass 1Final reportBeech 300/F · Front Royal, VAthe failure of the pilot-in-command to ensure that the airplane remained in visual meteorological conditions over mountainous terrain, and the failure of the Federal Aviation Administration executives and managers responsible for the FAA flying program to:…NTSB CHI94LA029Accident · No injuriesLimited investigationFinal reportCessna 182N · Onaga, KSthe pilot-in-command's poor pre-flight planning and failure to maintain runway alignment. Factors were the dark light conditions and the lack of runway lights.