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 CHI92FA110Accident · 2 fatalField investigationFinal reportCessna 310R · Superior, WIInadequate airspeed, which resulted in an inadvertent stall/spin, and failure of the instructor pilot to take sufficient remedial action to prevent the loss of control.NTSB ATL92LA059Accident · No injuriesLimited investigationFinal reportCessna 310R · Tuscaloosa, ALThe instructor's inadequate supervision and the student pilot's failure to follow instructions.NTSB ATL92LA058Accident · No injuriesLimited investigationFinal reportPiper PA-46-310 · Aiken, SCThe unexpected, gusting crosswind.NTSB ANC92T#A03Accident · No injuriesClass 3Final reportPiper PA-18 · Anchorage, AKNTSB NYC92LA054Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Falmouth, KYThe failure of the pilot to adequately monitor his fuel consumption which resulted in a power loss from fuel exhaustion over unsuitable terrain. A factor related to the accident was the failure of the pilot to adequately determine the amount of fuel onboard…NTSB MIA92LA095Accident · Serious injuriesLimited investigationFinal reportCessna 182 · Deland, FLFailure of the pilot-in-command to maintain the proper airspeed (vs) resulting in an inadvertent stall. Factors in the accident were incorrect fuel selector position resulting in the total loss of engine power due to fuel starvation and fatigue of the pilot.NTSB MIA92IA093Incident · No injuriesIncident investigationFinal reportDouglas DC-3C · San Juan, PRThe pilot-in-command's improper loading of personnel, and improper supervision of the first officer/co-pilot while calculating the center of gravity limits for the flight. This resulted in the forward center of gravity limit being exceeded and subsequent nose…NTSB BFO92LA037Accident · No injuriesLimited investigationFinal reportPiper 46-310P · Lima, OHThe pilot failure to maintian adequate airspeed during final approach which resulted in a stall. Contributing to the accident was ice on the wings.NTSB ANC92LA046Accident · Serious injuriesLimited investigationFinal reportPiper PA-18A-150 · Golovin, AKProper altitude was not maintained. Factors to the accident were: inadvertent VFR flight into IMC, fog, snow, and night.NTSB LAX92LA140Accident · No injuriesLimited investigationFinal reportCessna 172P · Santa Monica, CAThe pilot's misjudged landing flare and her improper bounced landing recovery technique. Contributing factors were the airplane's excessive approach airspeed and the student's lack of experience.NTSB LAX92LA139Accident · No injuriesLimited investigationFinal reportCessna 210G · Livermore, CAThe failure of the left main landing gear saddle.NTSB FTW92LA086Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Harrison, ARThe pilot's failure to attain the proper touchdown point, and his failure to maintain the proper descent rate.NTSB FTW92LA085Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Valley Mills, TXPower loss due inadequate maintenance and the resultant multiple maintenance discrepancies. A factor was the wet terrain.NTSB CHI92LA109Accident · No injuriesLimited investigationFinal reportCessna 177BII · Bloomington, ILPilot's improper recovery from a bounced landing. Factors in the accident were excessive airspeed at landing and habit interference.NTSB SEA92LA057Accident · 2 fatalLimited investigationFinal reportRobert L. Rice Davis DA-2A · Billings, MTThe failure of the pilot to maintain terrain clearance. Factors relating to the accident were the pilot's lack of experience and the rising terrain in the area.NTSB SEA92LA056Accident · 1 fatalLimited investigationFinal reportAero Commander S-2R · Dufur, ORThe pilot in command's misjudgment of clearance with the power lines. Factors contributing to the accident were: object (transmission wire) and safety system (not installed).NTSB MIA92LA092Accident · No injuriesLimited investigationFinal reportCessna 170A · Miami, FLFailure of the pilot in command to maintain directional control. Contributing to the accident was the unfavorable wind (windshift).NTSB FTW92LA084Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Mangum, OKThe pilot's failure to maintain proper airplane altitude. A factor was the dark night.NTSB FTW92LA082Accident · No injuriesLimited investigationFinal reportCessna 172B · Golden, TXFuel exhaustion due to the pilot's failure to refuel. Factors were false fuel sensor indications and a fence.NTSB FTW92DPG01Accident · 1 fatalFinal reportWind Ryder · Little Rock, ARA loss of control for undetermined reason(s).NTSB CHI92LA106Accident · Minor injuriesLimited investigationFinal reportSocata TB-10 · Elkhart, INProper glidepath was not maintained and minimum descent altitude was not maintained by the pilot resulting in collision with trees. Factors relate to the accident were the pilot's lack of total experience in type of operation and over confidence in personal…NTSB CHI92LA105Accident · No injuriesLimited investigationFinal reportPiper PA-23-150 · Romeoville, ILThe pilot selected unsuitable terrain to make a precautionary landing when he did not receive a safe indication that the landing gear was down and locked. A factor in the accident was inability of the pilot to restart the left engine after intentionally…NTSB ATL92LA057Accident · No injuriesLimited investigationFinal reportCessna 152 · Lawrenceville, GALoss of engine power for undetermined reasons.NTSB ATL92LA056Accident · Serious injuriesLimited investigationFinal reportJR. Ace E · Statesville, NCThe pilot's failure to maintain altitude during a steep turn at low level.NTSB ANC92T#A02Accident · No injuriesClass 3Final reportCessna 185 · Barrow, AKNTSB SEA92LA055Accident · 1 fatalLimited investigationFinal reportRobinson R-22 Beta · Oxbow, ORFailure of the pilot to maintain a proper visual lookout. A factor in the accident was the pilot's poor judgement in operating at low altitude along the river.NTSB MIA92LA094Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Hollandale, MSFailure of the pilot in command to check the fuel tank for contaminants before departure, which resulted in the total loss of engine power due to water contamination.NTSB FTW92LA087Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Santa Fe, NMThe pilot's failure to maintain directional control during the takeoff roll phase of a touch and go.NTSB FTW92LA083Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Whitehouse, TXThe pilot's inadequate preflight inspection and the engine power loss due to fuel contamination with water. A factor was the lack of suitable terrain available for the forced landing.NTSB FTW92LA081Accident · No injuriesLimited investigationFinal reportCameron 084 · Maumelle, ARThe pilots improper fuel consumption planning. A factor was a lack of suitable terrain for landing.NTSB DEN92LA041Accident · Minor injuriesLimited investigationFinal reportEnstrom F28 · Lakewood, COThe premature use of collective by the pilot during an autorotation. Factors were: the disconnection and subsequent collapse of the induction air line.NTSB CHI92LA107Accident · No injuriesLimited investigationFinal reportBeech C23 · Ozark, MOThe CFI pilot-in-command's failure to provide adequate supervision of a dual student. A factor contributing to the accident was the student pilot's failure to maintain airspeed.NTSB BFO92LA033Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Qioquinton, VAEngine failure due to fuel exhaustion because of an open crossfeed fuel line drain valve.NTSB BFO92FA032Accident · 2 fatalField investigationFinal reportPiper PA-23-250 · Sandston, VAThe pilot's improper in-flight planning/decision failure to follow the missed approach procedure.NTSB BFO92FA031Accident · 2 fatalField investigationFinal reportCessna 210K · Frederick, MDThe pilot's improper IFR operation and descent below the ILS glideslope and decision height, which resulted in an inflight collision with trees. The weather condition and lack of a recent weather briefing were related factors.NTSB ANC92FA044Accident · Serious injuriesField investigationFinal reportBell 214B-1 · Hobart Bay, AKFatigue failure of the compressor assembly impeller, and inadequate quality control by the manufacturer. A factor which contributed to the accident was the mountainous/hilly terrain.NTSB LAX92FA136Accident · 2 fatalField investigationFinal reportAerospatiale AS-350D · Ft. Grant, AZ1) The pilot inadequately evaluating the enroute weather conditions, and, 2) the pilot making the inflight decision to continue VFR flight into adverse weather conditions. Factors in this accident were the inability of the pilot to see the mountainous terrain…NTSB FTW92IA092Incident · No injuriesIncident investigationFinal reportBell 206L-3 · Sabine Pass #18The pilot's cardiovascular disease.NTSB DEN92FA040Accident · 6 fatalField investigationFinal reportMitsubishi MU-2B-60 · New Castle, COAn inadvertent stall during an instrument approach with the autopilot engaged. A factor was: the pilot's physical impairment from a prescription drug.NTSB CHI92FA104Accident · 3 fatalField investigationFinal reportCessna 414 · Freeland, MIThe pilot's poor judgement in attempting flight after the airplane's fuselage was damaged during a loading operation. Factors which contributed to the accident were: the operator's failure to provide proper weight and balance data for the airplane, the…NTSB BFO92LA030Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-201T · Brewer, METhe pilot's decision to land on an icy runway and then attempt to take off. Contributing to the accident was the pilot's decision to completely raise the flaps after the balked landing.NTSB MIA92LA091Accident · No injuriesLimited investigationFinal reportCessna 150K · Gainesville, FLThe improper in flight decision by the pilot-in-command to land with an excessive rate of descent and airspeed. Contributing to the accident was the pilot-in-command's improper recovery from a bounced landing which resulted in an on ground loss of control…NTSB LAX92FA137Accident · 1 fatalField investigationFinal reportRobinson R22 · Maricopa, AZDestructive mast bumping for an undetermined reason(s).NTSB LAX92FA135Accident · 2 fatalField investigationFinal reportCessna 150 · Williams, AZThe pilot inadequately evaluating the weather condition, and the pilot's inflight decision to continue flight into adverse weather conditions. Factors in this accident were the pilot's visual lookout ability being restricted by the prevailing weather…NTSB BFO92LA029Accident · No injuriesLimited investigationFinal reportCessna 195 · Charleston, WVFailure of the pilot to maintain clearance from the taxiway sign.NTSB FTW92GA080Accident · No injuriesFinal reportBell 206B III · Falfurrias, TXThe pilot's failure to maintain directional control due to his ability to maintain an adequate visual lookout being restricted. Factors were the observer's delay in informing the pilot of the rearward drift and the dark night conditions.NTSB CHI92LA102Accident · No injuriesLimited investigationFinal reportStinson 108 · Heyworth, ILImproper use of the carburetor heat control which resulted in carburetor ice and subsequent loss of power. A factor related to the accident was the carburetor icing conditions which existed at the time of the accident.NTSB CHI92IA101Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-10-10 · Chicago, ILContaminated anti-skid braking system electrical connectors which resulted in a partial loss of the anti-skid system and locking up of the brakes on the left main gear.NTSB ATL92LA054Accident · Minor injuriesLimited investigationFinal reportCessna 172L · Starr, SCThe pilot's inadequate pre-flight planning.NTSB ANC92LA043Accident · Minor injuriesLimited investigationFinal reportDouglas DC-6B · Selawik, AKThe pilot's inadequate pre flight planning and disregarding the aircraft performance data. Contributing factors were the extreme outside air temperatures, the icy runway, and the tailwind.