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.

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).Feb 23, 1992 · N5309W · DestroyedNTSB 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…Feb 23, 1992 · N814RM · DestroyedNTSB 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.Feb 22, 1992 · N2921G · Substantial damageNTSB 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.Feb 22, 1992 · N2169W · Substantial damageNTSB 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.Feb 22, 1992 · N9343C · Substantial damageNTSB 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.Feb 22, 1992 · N9066L · DestroyedNTSB FTW92FA073Accident · Serious injuriesField investigationFinal reportCessna 150 · Clarksville, ARThe pilots inadvertent stall. A factor was the operator's inadequate supervision.Feb 22, 1992 · N7896E · Substantial damageNTSB 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.Feb 21, 1992 · N738YY · 2 aircraft · Substantial damageNTSB 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.Feb 21, 1992 · N1405K · Substantial damageNTSB CHI92LA094Accident · No injuriesLimited investigationFinal reportCessna T210M · Washington, INThe total loss of engine power due to a fatigue-fractured crankshaft.Feb 21, 1992 · N732TR · Substantial damageNTSB SEA92LA050Accident · No injuriesLimited investigationFinal reportCessna 182D · Monroe, UTAn aborted takeoff was not performed. The wet, soft runway was a factor.Feb 20, 1992 · N9030X · Substantial damageNTSB NYC92LA063Accident · No injuriesLimited investigationFinal reportCessna 150D · Moneta, VAThe pilot's failure to maintain directional control of the airplane during landing with a crosswind.Feb 20, 1992 · N4373U · Substantial damageNTSB CHI92LA092Accident · No injuriesLimited investigationFinal reportCessna 340A · Lapeer, MIThe pilot's failure to maintain directional control.Feb 20, 1992 · N5349J · Substantial damageNTSB 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…Feb 20, 1992 · N332DD · Substantial damageNTSB 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.Feb 19, 1992 · N33464 · Substantial damageNTSB 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.Feb 19, 1992 · N4948Q · Substantial damageNTSB 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.Feb 17, 1992 · N96617 · Substantial damageNTSB SEA92FA049Accident · 2 fatalField investigationFinal reportCessna 150M · Pullman, WAPoor inflight planning/decision. Factors to the accident were bright night conditions and clearance not maintained.Feb 17, 1992 · N66473 · DestroyedNTSB 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…Feb 17, 1992 · N60AW · DestroyedNTSB 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.Feb 17, 1992 · N738EC · Substantial damageNTSB ATL92LA046Accident · No injuriesLimited investigationFinal reportCessna 172 · Leesburg, FLThe unfavorable wind conditions encountered by the flight during taxi.Feb 17, 1992 · N53370 · Substantial damageNTSB 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.Feb 17, 1992 · N24211 · Substantial damageNTSB 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.Feb 17, 1992 · N82380 · Substantial damageNTSB 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…Feb 16, 1992 · N6559F · Substantial damageNTSB 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.Feb 16, 1992 · N231NR · DestroyedNTSB 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…Feb 16, 1992 · N3011W · Substantial damageNTSB 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.Feb 15, 1992 · N8000Z · DestroyedNTSB 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.Feb 15, 1992 · N6544G · 2 aircraft · Substantial damageNTSB 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.Feb 15, 1992 · N36142 · Substantial damageNTSB 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.Feb 15, 1992 · N1107M · Substantial damageNTSB 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.Feb 15, 1992 · N64ND · DestroyedNTSB 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.Feb 15, 1992 · N3120X · DestroyedNTSB 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…Feb 15, 1992 · N794AL · DestroyedNTSB 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.Feb 15, 1992 · N1778K · Substantial damageNTSB 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…Feb 14, 1992 · N6907C · Substantial damageNTSB 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…Feb 14, 1992 · N4380T · DestroyedNTSB LAX92T#A03Accident · No injuriesClass 3Final reportMcdonnell Douglas 369D · Mesa, AZFeb 14, 1992 · N911FT · Substantial damageNTSB 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.Feb 14, 1992 · N48360 · DestroyedNTSB 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.Feb 14, 1992 · N33AP · Substantial damageNTSB 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.Feb 14, 1992 · N26JB · DestroyedNTSB 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.Feb 14, 1992 · N2788X · Substantial damageNTSB 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.Feb 13, 1992 · N92RL · DestroyedNTSB 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.Feb 13, 1992 · N4644G · Substantial damageNTSB 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.Feb 13, 1992 · N89071 · Substantial damageNTSB 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.Feb 13, 1992 · N3877P · Substantial damageNTSB 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.Feb 12, 1992 · CGRRZ · DestroyedNTSB 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.Feb 12, 1992 · N5003U · DestroyedNTSB 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.Feb 12, 1992 · N99TV · Substantial damageNTSB BFO92TA#01Accident · No injuriesFinal reportMcdonnell Douglas 369E · Clinton, MDFeb 12, 1992 · N1600Q · Substantial damageNTSB 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.Feb 12, 1992 · N5154U · Substantial damage