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 ATL98LA065Accident · No injuriesLimited investigationFinal reportSchweizer 269C · San Juan, PRThe pilot's failure to adequately secure the cargo strap which became entangled in the tail rotor, leading to a loss of the tail rotor control. This was followed by an improperly executed emergency procedure and an in-flight collision with the ground. A…Apr 27, 1998 · N61193 · Substantial damageNTSB SEA98LA067Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Arlington, WAThe pilot's failure to maintain directional control during the landing roll, and his delayed remedial action when the aircraft started to drift off the side of the runway.Apr 26, 1998 · N7458K · Substantial damageNTSB NYC98LA102Accident · 1 fatalLimited investigationFinal reportPiper PA-32-300 · New Bedford, MAThe pilot's impairment due to alcohol, which resulted in an inadequate preflight examination and subsequent takeoff with a control lock installed.Apr 26, 1998 · N15326 · Substantial damageNTSB MIA98LA146Accident · No injuriesLimited investigationFinal reportCessna 172RG · Greenville, SCThe pilot's use of full flaps while landing in a strong crosswind resulting in loss of directional control during the landing roll.Apr 26, 1998 · N9769B · Substantial damageNTSB MIA98LA145Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Fruitland Park, FLthe pilot's failure to attain the proper rate of descent at touchdown.Apr 26, 1998 · N154CH · Substantial damageNTSB MIA98LA144Accident · No injuriesLimited investigationFinal reportPiper PA-18 · St. Petersburg, FLThe intentional operation of the airplane by the pilot and the company/operator with the known deficiencies in equipment (worn carburetor). Also, the poor preflight planning by the pilot for his failure to recognize that the carburetor heat control was…Apr 26, 1998 · N225NY · Substantial damageNTSB LAX98LA143Accident · No injuriesLimited investigationFinal reportCessna 172M · Henderson, NVThe pilot's decision to attempt a landing in crosswind conditions at or above the demonstrated capability of the aircraft, and his subsequent failure to maintain proper runway alignment.Apr 26, 1998 · N64006 · Substantial damageNTSB LAX98LA142Accident · No injuriesLimited investigationFinal reportBeech C23 · Tulare, CAThe malfunction of the nose wheel steering for undetermined reasons.Apr 26, 1998 · N9144S · Substantial damageNTSB IAD98FA049Accident · 2 fatalField investigationFinal reportFairchild Hiller FH-1100 · Stevensville, MDThe pilot's abrupt, low-g maneuver, which resulted in mast bumping and separation of the main rotor system.Apr 26, 1998 · N1345Q · DestroyedNTSB FTW98FA393Accident · 1 fatalField investigationFinal reportCessna T310R · Pie Town, NMThe pilot's continuing VFR flight into instrument meteorological conditions. Contributing factors were weather conditions, that included clouds, and mountainous terrain.Apr 26, 1998 · N467DL · DestroyedNTSB FTW98FA192Accident · 3 fatalField investigationFinal reportBeech BE-58 · Kerrville, TXThe non-instrument rated pilot's failure to maintain aircraft control due to spatial disorientation. Factors were the dark night conditions, overcast skies, and the pilot's inadequate preflight planning.Apr 26, 1998 · N60UU · DestroyedNTSB DCA98WA053Accident · 1 fatalForeign investigationCessna 210 · Eucembune, AustraliaApr 26, 1998 · VHIOR · DestroyedNTSB ATL98LA067Accident · 1 fatalLimited investigationFinal reportUnknown Freebird Sport · Englewood, FLThe inadvertent aerodynamic stall, and subsequent loss of control in-flight by the non-certificated pilot. A factor was the use of over the counter drugs which are known to cause drowsiness.Apr 26, 1998 · UNREG · DestroyedNTSB ANC98LA042Accident · No injuriesLimited investigationFinal reportCessna 172M · Anchor Point, AKThe pilot's failure to compensate for a crosswind. A related factor was the crosswind.Apr 26, 1998 · N8969V · Substantial damageNTSB NYC98LA098Accident · No injuriesLimited investigationFinal reportMasak Scimitar · Hardscrabble, VAThe pilots encounter with an unexpected downdraft.Apr 25, 1998 · N102PX · Substantial damageNTSB MIA98LA148Accident · No injuriesLimited investigationFinal reportBell 206L-1 · Orlando, FLfailure of the flight crew to maintain main rotor RPM during a landing touchdown, which resulted in the main rotor blades contacting the tailboom.Apr 25, 1998 · N60WJ · Substantial damageNTSB MIA98LA143Accident · Minor injuriesLimited investigationFinal reportOrlando Heli Air TR-2000 · Lakeland, FLThe pilot's failure to obtain the proper touch down point (landed left of runway) on landing.Apr 25, 1998 · N202TR · Substantial damageNTSB LAX98LA148Accident · No injuriesLimited investigationFinal reportCessna 150G · Oroville, CAThe pilot's failure to maintain the proper glide path, and his inadequate compensation for wind conditions, which resulted in an undershoot.Apr 25, 1998 · N3376J · Substantial damageNTSB IAD98LA048Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Downsville, NYThe pilot's failure to maintain directional control of the airplane.Apr 25, 1998 · N3757V · Substantial damageNTSB FTW98LA240Accident · No injuriesLimited investigationFinal reportCessna 172P · La Porte, TXThe pilot's premature landing flare and improper recovery procedures from a bounced landing. A factor was the gusty winds.Apr 25, 1998 · N52188 · Substantial damageNTSB FTW98LA198Accident · No injuriesLimited investigationFinal reportCessna 172N · Parker, COa fractured #1 exhaust valve rocker arm stud, which subsequently resulted in loss of engine power and a forced landing. The lack of suitable terrain in the forced landing area was a related factor.Apr 25, 1998 · N6356D · Substantial damageNTSB FTW98LA194Accident · Serious injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Oberlin, LAThe pilot's failure to maintain aircraft control. A factor was the gusty wind.Apr 25, 1998 · N63E · DestroyedNTSB FTW98LA193Accident · Serious injuriesLimited investigationFinal reportLerille P & W 1937 · Lafayette, LAThe fuel exhaustion due to the pilot's failure to refuel. A factor was the lack of suitable terrain for the forced landing.Apr 25, 1998 · N546R · Substantial damageNTSB CHI98LA135Accident · No injuriesLimited investigationFinal reportCessna C-182 · Emporia, KSThe pilot's failure to maintain control of the airplane. Factors contributing to this accident were the strong crosswind and the wind gusts.Apr 25, 1998 · N5305B · Substantial damageNTSB CHI98LA134Accident · No injuriesLimited investigationFinal reportCessna 172 · Eagle River, WIthe pilot failed to compensate for the wind conditions, improperly executed a go-around when he raised the flaps, and failed to maintain obstacle clearance with the trees.Apr 25, 1998 · N79006 · Substantial damageNTSB ANC98LA041Accident · No injuriesLimited investigationFinal reportCessna 170B · Kenai, AKA failure of the number six cylinder rod bearing and connecting rod cap for undetermined reasons. Factors in the accident were snow covered terrain that was unsuitable for a forced landing.Apr 25, 1998 · N2692D · Substantial damageNTSB NYC98LA101Accident · Serious injuriesLimited investigationFinal reportBeech D95A · Mount Sterling, KYWas the failure of the flight instructor to feather the engine in a timely manner. Factors were improper placement of the fuel selector valve by the student and failure of the flight instructor to adequately supervise its placement.Apr 24, 1998 · N479AM · DestroyedNTSB MIA98LA142Accident · Minor injuriesLimited investigationFinal reportCessna 172RG · Sanford, FLThe inadvertent stall of the airplane and inadequate supervision of the student by the CFI-PIC while performing a soft field takeoff.Apr 24, 1998 · N9303D · Substantial damageNTSB LAX98FA141Accident · 2 fatalField investigationFinal reportCessna 172 · Ramona, CAThe loss of control of the aircraft on final approach for undetermined reasons.Apr 24, 1998 · N8364L · DestroyedNTSB IAD98FA047Accident · 1 fatalField investigationFinal reportBeech 58 · Columbus, OHThe pilot's inadequate planned approach and his failure to follow wake turbulence avoidance procedures by not staying above the glide-path of the preceding Boeing 757, which resulted in a vortex turbulence encounter. Contributing to the accident was the wake…Apr 24, 1998 · N258B · DestroyedNTSB FTW98LA197Accident · No injuriesLimited investigationFinal reportRockwell 690B · Broomfield, COFailure of the flight instructor to maintain adequate supervision, and failure of the pilot receiving instruction to maintain directional control that was lost for reasons undetermined. A factor was the concrete culvert.Apr 24, 1998 · N690ES · Substantial damageNTSB FTW98LA195Accident · No injuriesLimited investigationFinal reportBell 206B · Jasper, TXthe pilot's encounter with a dynamic rollover after the toe of the left skid became caught on a trailer, while attempting to land the trailer. A related factor was: the pilot's perception of pressure, which was induced by a need to perform a scheduled…Apr 24, 1998 · N108RL · Substantial damageNTSB FTW98FA191Accident · 1 fatalField investigationFinal reportBeech F33A · Del Rio, TXthe pilot's loss of control during a go-around after impacting approach light poles on initial approach. A contributing factor was the prevailing dark night light condition.Apr 24, 1998 · N2179L · DestroyedNTSB CHI98LA141Accident · No injuriesLimited investigationFinal reportCessna 172M · Superior, NEthe pilot's failure to maintain clearance with the sign. Factors associated with the accident were the sign which the airplane contacted and inadequate preflight planning/preparation.Apr 24, 1998 · N13834 · Substantial damageNTSB MIA98LA147Accident · No injuriesLimited investigationFinal reportWaco 10 GXE · Americus, GAThe pilot's failure to maintain directional control and his improper compensation for wind. Contributing was a crosswind.Apr 23, 1998 · N903H · Substantial damageNTSB LAX98LA150Accident · No injuriesLimited investigationFinal reportPitts S-2B · Greenfield, CAThe pilot's failure to maintain directional control. A related factor was the proximity of high brush located on both sides of the runway.Apr 23, 1998 · N6027V · Substantial damageNTSB FTW98FA190Accident · 2 fatalField investigationFinal reportCessna 150H · Parowan, UTThe pilot's failure to maintain sufficient airspeed and the subsequent inadvertent stall/spin. Factors were the high density altitude, the high, gusty wind condition, and the diverted attention of the pilot.Apr 23, 1998 · N50385 · DestroyedNTSB SEA98LA066Accident · Minor injuriesLimited investigationFinal reportErcoupe 415-D · Colstrip, MTThe pilot's operation of the aircraft above maximum gross weight, resulting in her inability to attain a sustained climb rate after becoming airborne. A factor was high density altitude conditions.Apr 22, 1998 · N2777H · Substantial damageNTSB ANC98LA040Accident · Minor injuriesLimited investigationFinal reportCessna 207A · Scammon Bay, AKThe pilot's continued VFR flight into instrument meteorological conditions. Factors in the accident were low ceilings, and whiteout conditions.Apr 22, 1998 · N7438U · Substantial damageNTSB SEA98LA065Accident · No injuriesLimited investigationFinal reportKaman K-1200 · La Grande, ORThe pilot's inadvertent shutdown of the engine with the FUEL/OIL shutoff switch. Contributing to the accident were: the manufacturer's inadequate location and design of the FUEL/OIL shutoff switch; the FAA's inadequate determination of the type design's…Apr 21, 1998 · N224GM · Substantial damageNTSB NYC98LA097Accident · Serious injuriesLimited investigationFinal reportLet L-23 Super Blanik · Pipersville, PAthe pilot's misjudgment of distance and altitude, while on an approach to an off-airport landing area, which resulted in a lack of airspeed and/or altitude to reach the intended landing area (undershoot), a stall or mush into tree(s), and collision with a…Apr 21, 1998 · N298BA · Substantial damageNTSB MIA98LA141Accident · 1 fatalLimited investigationFinal reportStar-Lite Engineering Warp 1A · Lakeland, FLthe pilot's failure to maintain airspeed, while maneuvering on crosswind in the traffic pattern, which resulted in an inadvertent stall, and an in-flight collision with a building and the terrain. Factors relating to the accident were: the pilot's decision to…Apr 21, 1998 · N914SL · DestroyedNTSB LAX98LA140Accident · No injuriesLimited investigationFinal reportBell 206L-1 · Los Angeles, CAAn overtemp of the engine during start within 10 hours of the accident, and the failure to report the event to the maintenance facility.Apr 21, 1998 · N87WC · Substantial damageNTSB FTW98FA189Accident · 2 fatalField investigationFinal reportCessna 150F · Muskogee, OKThe inadvertent stall as result of the pilot's failure to retract the flaps from the fully extended position prior to takeoff. Factors were the gusting winds and the pilot's failure to follow the before takeoff checklist.Apr 21, 1998 · N8720G · DestroyedNTSB SEA98LA064Accident · No injuriesLimited investigationFinal reportBell 47G-3B-1 · Sedro Wooley, WAFuel contamination and subsequent carburetor fuel flow restriction initiated by the use of an improper material (incorrect fuel hose). A factor was the trees.Apr 20, 1998 · N80SD · DestroyedNTSB NYC98FA095Accident · 1 fatalField investigationFinal reportMooney M20J · Bridgeport, CTThe pilot's failure to maintain control of the airplane during night instrument meteorological conditions. Contributing factors were dark night conditions, low ceilings, rain, and his decision to divert to an airport under instrument meteorological conditions…Apr 20, 1998 · N40HL · DestroyedNTSB MIA98LA140Accident · No injuriesLimited investigationFinal reportPiper PA-46-310P · Beaufort, SCThe partial loss of engine power for undetermined reasons.Apr 20, 1998 · N77DE · Substantial damageNTSB MIA98LA139Accident · No injuriesLimited investigationFinal reportBeech 58 · Tampa, FLThe pilot's failure to maintain runway alignment during touchdown.Apr 20, 1998 · N338CB · Substantial damageNTSB MIA98LA138Accident · Minor injuriesLimited investigationFinal reportKaas Express · Lakeland, FLThe pilot's failure to maintain directional control during landing flare/touchdown.Apr 20, 1998 · N12EX · Substantial damageNTSB MIA98LA137Accident · No injuriesLimited investigationFinal reportBennett M-500A · Lakeland, FLa hex nut on the cyclic flight control pushrod bolt had backed off for undetermined reason(s) and allowed the bolt to become disconnected from the control yoke teeter block, resulting in a loss of cyclic control and subsequent roll over during an emergency…Apr 20, 1998 · N105WB · Substantial damage