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 CHI92FA095Accident · 1 fatalField investigationFinal reportPiper PA-28-160 · Burlington, ILThe pilot's failure to maintain aircraft control after encountering instrument meteorological conditions in cruise flight. Related factors are the pilot's inadequate weather evaluation, the low ceiling and reduced visibility (fog).NTSB ANC92FA040Accident · 6 fatalField investigationFinal reportBell 214B-1 · Hobart Bay, AKSeparation of the tail rotor and 90 degree gearbox due to the pilot's failure to follow procedures/directives which resulted in the external load cable becoming entangled in the tail rotor. Factors were the turbulent weather and the lack of suitable terrain…NTSB NYC92LA064Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300 · Fredericksburg, VAThe failure of the pilot to maintain the proper glide path. Factors related to the accident were delayed remedial action by the pilot and night conditions.NTSB LAX92LA123Accident · No injuriesLimited investigationFinal reportBeech C-23 · Fullerton, CAWas the pilot's poorly planned approach. Contributing to this accident was the prevailing haze/smoke, the pilot's failure to attain a proper glidepath, proper touch down point and excessive final approach airspeed.NTSB LAX92LA122Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-201T · Ludlow, CAThe failure of the repair station to adequately perform a top overhaul and comply with a service bulletin. Contributing to this accident was the failure of the connecting rod due to fatigue and unsuitable terrain.NTSB LAX92FA121Accident · 1 fatalField investigationFinal reportGrumman American AA1B · Agua Dulce, CAThe pilot's abrupt aircraft control and failure to maintain airspeed. Contributing to this accident was the inadvertent stall/spin.NTSB FTW92FA073Accident · Serious injuriesField investigationFinal reportCessna 150 · Clarksville, ARThe pilots inadvertent stall. A factor was the operator's inadequate supervision.NTSB MIA92LA086Accident · No injuriesLimited investigationFinal reportCessna 172N · Orlando, FLThe pilots in command of both aircraft failure to maintain vigilance and see and avoid each other resulting in a midair collision. Contributing to the accident was the local controllers failure to issue traffic advisories.NTSB CHI92LA097Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Alpena, MIThe student pilot's failure to attain the proper touchdown point. Related factors are his misjudged approach and failure to take remedial action.NTSB CHI92LA094Accident · No injuriesLimited investigationFinal reportCessna T210M · Washington, INThe total loss of engine power due to a fatigue-fractured crankshaft.NTSB SEA92LA050Accident · No injuriesLimited investigationFinal reportCessna 182D · Monroe, UTAn aborted takeoff was not performed. The wet, soft runway was a factor.NTSB NYC92LA063Accident · No injuriesLimited investigationFinal reportCessna 150D · Moneta, VAThe pilot's failure to maintain directional control of the airplane during landing with a crosswind.NTSB CHI92LA092Accident · No injuriesLimited investigationFinal reportCessna 340A · Lapeer, MIThe pilot's failure to maintain directional control.NTSB ATL92LA048Accident · Serious injuriesLimited investigationFinal reportPiper PA32-300 · Hickory, NCWhile on final approach for a visual landing, the pilot reported an unspecified problem to the flight service station and elected to go around. The airplane crashed 300 feet short of the runway on the second approach. Examination of the accident site…NTSB ATL92FA047Accident · 2 fatalField investigationFinal reportPiper PA-28R-200 · Raleigh, NCThe failure of the pilot to follow instrument landing procedures by descending below the glide path of the instrument landing system. Factors in the accident were the low ceilings and fog at the airport at the time of the accident.NTSB ANC92LA039Accident · Minor injuriesLimited investigationFinal reportCessna 185F · Pelican, AKThe pilot's inadequate visual lookout during takeoff. Contributing to the accident was the glare from the sun.NTSB SEA92LA048Accident · No injuriesLimited investigationFinal reportCessna 172P · Nordman, IDThe pilot selected unsuitable terrain. Factors contributing to the accident were: the snow covered runway, and the pilot in command's inadequate preflight planning.NTSB SEA92FA049Accident · 2 fatalField investigationFinal reportCessna 150M · Pullman, WAPoor inflight planning/decision. Factors to the accident were bright night conditions and clearance not maintained.NTSB LAX92FA120Accident · 7 fatalField investigationFinal reportPiper PA-31T-II · Big Bear, CAThe pilot's poor judgement in continuing visual flight into instrument meteorological conditions, in mountainous terrain obscured by clouds. Factors in the accident were: the pilot's failure to obtain a preflight weather briefing, the weather conditions, and…NTSB FTW92LA071Accident · No injuriesLimited investigationFinal reportCessna 172 · Conroe, TXThe pilot's inadequate preflight which resulted in water in the fuel system. A factor was the night lighting condition.NTSB ATL92LA046Accident · No injuriesLimited investigationFinal reportCessna 172 · Leesburg, FLThe unfavorable wind conditions encountered by the flight during taxi.NTSB ATL92LA045Accident · No injuriesLimited investigationFinal reportCessna 152 · Naples, FLThe pilot's inadequate preflight planning and his failure to refuel at his last departure point, which resulted in fuel exhaustion and engine stoppage.NTSB ANC92LA037Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Sitka, AKThe pilot/flight instructor's loss of directional control during the landing roll and the subsequent ground loop/swerve. Contributing to the accident was the gusty crosswind condition.NTSB NYC92FA062Accident · 1 fatalField investigationFinal reportCessna 150 · White Lake, NYThe pilot's improper decision to fly into known adverse weather conditions, his failure to maintain control of the airplane, and his impairment of judgement due to drugs. Factors which contributed to the accident were: the dark night, the adverse weather…NTSB NYC92FA061Accident · 1 fatalField investigationFinal reportMooney M20K · Wheeling, WVThe pilot's failure to maintain airspeed and his improper handling of the aircraft which resulted in an inadvertent stall at an altitude insufficient for proper recovery. A factor related to the accident was icing conditions which resulted in airframe ice.NTSB MIA92LA088Accident · No injuriesLimited investigationFinal reportBeech E-55 · Tallahassee, FLFailure of the pilot to attain the proper airspeed (vhc) before rotation which resulted in failure to maintain directional control following total loss of engine power from the right engine. Contributing to the accident was failure of the right engine, engine…NTSB SEA92LA047Accident · Minor injuriesLimited investigationFinal reportKna,Ken,Dac,Wel Tern Sailplane · Cottage Grove, ORThe pilot's inadequate preflight of the sailplane. Factors contributing to the accident were improper tow equipment and lack of total glider experience.NTSB NYC92LA069Accident · No injuriesLimited investigationFinal reportCessna 150 · Sanford, METhe failure of the pilot of N64147 to maintain adequate spacing and visual lookout from N6544G while taxiing, resulting in a ground collision.NTSB NYC92LA060Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-20 · Isle Au Haut, MEFuel system icing and contamination which resulted in a loss of engine power and subsequent stall and loss of control during a forced landing.NTSB LAX92LA119Accident · No injuriesLimited investigationFinal reportRobinson R-22M · Chandler, AZThe pilot not maintaining the proper descent rate and misjudging the landing flare which resulted in the aircraft pitching forward and rolling over.NTSB LAX92LA118Accident · Minor injuriesLimited investigationFinal reportAvions Mudry CAP-10B · Santa Paula, CAThe failure of the airplanes's left wing spar due to stress overloading caused by pre-existing compression failures in the laminate.NTSB FTW92LA070Accident · No injuriesLimited investigationFinal reportBell 206L-3 · South Pelto #1The pilot's inability to control the helicopter due to spatial disorientation. Factors were the fog and the pilot's failure to receive a weather briefing prior to the flight.NTSB DCA92MA022Accident · 4 fatalMajor investigationFinal reportDouglas DC-8-63 · Swanton, OHThe failure of the flightcrew to properly recognize or recover in a timely manner from the unusual aircraft attitude that resulted from the captain's apparent spatial disorientation, resulting from physiological factors and/or a failed attitude director…NTSB CHI92LA091Accident · Minor injuriesLimited investigationFinal reportLuscombe 8E · Farrar, MOPremature liftoff and poor planning by the pilot. Factors related to the accident were the tailwind and misjudged compensation for it along with the rough uneven terrain.NTSB NYC92LA058Accident · No injuriesLimited investigationFinal reportPiper PA60-700P · Wooster, OHThe pilot allowed the airspeed to decay, delayed the go-around, and prematurely rotated the airplane which resulted in the airplane over running the runway. Factor in the accident were the pilot inadequately planned the approach; freezing drizzle and runway…NTSB NYC92FA059Accident · 3 fatalField investigationFinal reportPiper PA-32-301 · Heath, OHAn inadvertent stall with insufficient altitude for recovery. An additional cause was the pilot's self induced pressure to complete the fight in known adverse weather, and to deviate from the published instrument approach procedure. Factors related to the…NTSB LAX92T#A03Accident · No injuriesClass 3Final reportMcdonnell Douglas 369D · Mesa, AZNTSB LAX92LA117Accident · No injuriesLimited investigationFinal reportCessna 152 · Show Low, AZThe total loss of engine power due to undetermined reason(s). A factor in this accident was the soft soil the airplane encountered during landing roll which caused the airplane to nose over.NTSB LAX92LA116Accident · No injuriesLimited investigationFinal reportBeech D-18H · Lanai, HIFailure of the pilot to compensate for an encounter with a windshear phenomena. Contributing to the accident was the lack of a low level windshear warning system or a system for the collection and dissemination of weather advisories.NTSB DEN92FA035Accident · Serious injuriesField investigationFinal reportSwearingen SA-26AT · Glenwood Spring, COMalfunction of the right engine fuel control that caused the engine to flame out, and delamination of the left engine compressor shroud. Factors were: the pilot became disoriented, the mountainous terrain, the dark night, and the weather conditions.NTSB ANC92LA038Accident · Serious injuriesLimited investigationFinal reportCessna 180 · Shishmaref, AKThe non-instrumented rated pilot-in-command attempted visual flight into known instrument meteorological conditions. Factors contributing to the accident were the fog, the icing conditions, and the pilot's over confidence in his personal ability.NTSB FTW92LA069Accident · Serious injuriesLimited investigationFinal reportRalph Legate Stits Skycoup · Conway, ARThe pilot's failure to maintain proper clearance with the guy wire. A factor was the fuel starvation caused by failure of the carburetor float.NTSB CHI92LA090Accident · No injuriesLimited investigationFinal reportCessna 414 · Logansport, INThe pilot's failure to maintain an adequate approach speed which resulted in an improper flare. Factors contributing to the accident were the inadequate inflight deicing of the airframe surfaces and in icing conditions encountered.NTSB ATL92LA044Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Macon, GAThe improper in-flight decision by the instructor pilot to attempt a precautionary off airport landing when no emergency existed. Factors related to the accident were the fog and low ceilings in the area at the time.NTSB ANC92LA035Accident · Minor injuriesLimited investigationFinal reportPiper PA-18A-150 · Anchorage, AKThe pilot's misjudgment of the fuel consumption of the airplane; thereby exhausting the fuel supply prematurely. Factor relating to the accident was the lack of a suitable forced landing area.NTSB SEA92FA046Accident · 2 fatalField investigationFinal reportGrumman American AA-5B · West Glacier, MTThe inflight encounter with IMC weather by the non-instrument rated pilot. Factors relating to the accident were the weather conditions, the mountainous/hilly terrain, and lack of instrument qualification by the pilot.NTSB SEA92FA045Accident · 2 fatalField investigationFinal reportBell 206B · Wellington, UTThe pilot's continued flight into adverse weather conditions and an excessive rate of descent. Factors contributing to the accident were fog, rain, low ceilings, night conditions, snow covered terrain and pilot disorientation.NTSB DEN92FA034Accident · 2 fatalField investigationFinal reportBell 206L-3 · Fort Collins, COFailure of the number 2-1/2 bearing due to an obstruction of a bearing oil feed tube by foreign material. Factors related to the accident were: improper maintenance during engine overhaul, and weather/terrain/water conditions in the emergency landing area.NTSB BFO92TA#01Accident · No injuriesFinal reportMcdonnell Douglas 369E · Clinton, MDNTSB ANC92LA036Accident · No injuriesLimited investigationFinal reportRichard C. Ballow Kitfox 1 · Valdez, AKThe pilot's improper use of the airplane's brakes. Factors which contributed to the accident were the icy runway condition and the pilot's lack of total experience with this type of operation.