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 FTW95LA343Accident · No injuriesLimited investigationFinal reportPark Wizard · Mineral Wells, TXA seized engine following the total loss of engine coolant from a loose line due to an inadequate maintenance installation by the builder. A factor was the lack of suitable terrain for the forced landing.NTSB FTW95LA342Accident · No injuriesLimited investigationFinal reportBeech 19 · Lago Vista, TXThe loss of engine power for undetermined reasons.NTSB FTW95LA341Accident · No injuriesLimited investigationFinal reportBoeing B75N1 · Englewood, COFailure by the pilot to maintain directional control which resulted in a ground loop. A factor was crosswind.NTSB FTW95LA340Accident · No injuriesLimited investigationFinal reportBeech J35 · Englewood, COInadvertent activation of the fuel boost pump by either the pilot (who was being instructed) or by the flight instructor (CFI). Factors relating to the accident were: the briefing of improper leaning procedures by the CFI, location of the boost pump switch…NTSB CHI95LA283Accident · No injuriesLimited investigationFinal reportPiper PA-31 · Ironwood, MIthe pilot's failure to maintain control of the airplane during the aborted takeoff. A factor was the partial loss of engine power for an undetermined reason.NTSB CHI95LA279Accident · No injuriesLimited investigationFinal reportCessna 188B · Canton, KSfailure of the pilot to obtain the proper flying speed or to abort the takeoff, while there was sufficient runway remaining, which resulted in an inadvertent stall.NTSB CHI95LA276Accident · No injuriesLimited investigationFinal reportCessna A185E · Dickinson, NDthe pilot's inadequate compensation for the wind conditions, and his improper recovery from the bounced landing. The high wind was a factor.NTSB CHI95LA274Accident · Minor injuriesLimited investigationFinal reportCessna 188 · Meade, KSa fatigue failure of the propeller blade, and inadequate maintenance inspection performed by the propeller shop.NTSB ANC95LA138Accident · No injuriesLimited investigationFinal reportPiper PA-32-301 · Togiak, AKThe pilot's inadequate compensation for wind conditions and failure to maintain proper alignment with the intended point of landing. A factor relating to the accident was: the unfavorable wind condition.NTSB SEA95LA182Accident · No injuriesLimited investigationFinal reportCessna 177B · Seattle, WALoss of engine power for undetermined reason(s).NTSB NYC95LA189Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Erwinna, PAthe flight instructor's inadequate supervision during the final approach which resulted in the student flying a low approach and a subsequent collision with the trees. A factor relating to the accident was the student pilot's failure to maintain a proper…NTSB MIA95LA204Accident · 1 fatalLimited investigationFinal reportCessna A188B · Muscle Shoals, ALFailure of the pilot to maintain adequate visual lookout to see-and-avoid electrical power lines, while approaching a field for aerial application.NTSB MIA95LA203Accident · Serious injuriesLimited investigationFinal reportFairchild 24-G · Harold, FLThe engine missing for undetermined reasons, and the failure of the pilot in command to maintain airspeed while turning toward a landing area.NTSB MIA95LA202Accident · No injuriesLimited investigationFinal reportCessna 150M · Knightdale, NCThe failure of the pilot to maintain runway alignment. Contributing to the accident was the failure of the pilot to execute a go-around when he saw that he would not land on the runway.NTSB CHI95LA272Accident · Minor injuriesLimited investigationFinal reportGrumman G-164 · Wadena, MNthe pilot's inattentiveness during the reversal turn, the pilot not maintaining control of the airplane, and the stall/mush encountered by the pilot.NTSB CHI95LA268Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Auburn, INthe pilot's impairment of judgement and performance due to alcohol which led to his failure to maintain control of the airplane.NTSB BFO95LA085Accident · Serious injuriesLimited investigationFinal reportBirdman Enterprises Chinook 2S · Hammondsville, OHthe pilot's failure to maintain adequate altitude/clearance from obstacles (power lines) in his flight path.NTSB BFO95LA080Accident · No injuriesLimited investigationFinal reportCessna 182F · Mitchellville, MDthe pilot's delay in aborting the takeoff.NTSB SEA95LA181Accident · Serious injuriesLimited investigationFinal reportTaylorcraft BC12D · St. Mary, MTThe pilot-in-command's failure to maintain proper altitude while maneuvering in high, mountainous, terrain. The terrain and the downdrafts were factors.NTSB NYC95TA190Accident · Minor injuriesFinal reportSchweizer 269C · Baltimore, MDThe pilot's failure to maintain adequate terrain clearance which resulted in an inflight collision with the ground.NTSB NYC95LA187Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Norfolk, MAThe pilot's misjudgement of speed and distance during the landing, which resulted in a runway overrun. Factors relating to the accident were: heavy rain, wet runway, and hydroplaning conditions.NTSB LAX95LA293Accident · No injuriesLimited investigationFinal reportPitts S-2B · Phoenix, AZThe inadequate supervision by the instructor pilot by allowing the trainee to initiate a late go-around from a simulated forced landing.NTSB LAX95LA292Accident · Minor injuriesLimited investigationFinal reportPiper PA-32R-301T · Truckee, CAA failure in the aircraft electrical system, and the pilot's failure (or inability) to extend the landing gear with the emergency extension system. A factor relating to the accident was: the pilot's decision to continue the flight with a known deficiency.NTSB LAX95LA291Accident · Serious injuriesLimited investigationFinal reportKinner Sportster K · Los Banos, CAthe pilot's failure to maintain minimum control airspeed resulting in a stall, and not maintaining proper altitude on final approach. Contributing to the accident was the unfavorable wind condition.NTSB LAX95LA290Accident · Serious injuriesLimited investigationFinal reportPiper PA-30-B · Wickenberg, AZthe pilot's improper emergency procedures. The pilot's diverted attention, and the magnetos clearance and timing were factors in this accident.NTSB LAX95LA289Accident · 1 fatalLimited investigationFinal reportRonneberg/Murphy Berkut · Santa Paula, CAthe pilot's inadvertent entry into an accelerated stall in a maximum performance high-g turn at an altitude insufficient to recover aircraft control prior to colliding with the ground.NTSB FTW95LA339Accident · No injuriesLimited investigationFinal reportReims Cessna FR182 · Lakeview, ARThe pilot's improper recovery from a bounced landing, and failure to maintain directional control. Factors related to the accident were: the pilot's failure to attain the proper touchdown point or abort the landing.NTSB FTW95LA338Accident · Serious injuriesLimited investigationFinal reportGeneral Balloon Newport AX8 · Houston, TXThe loss of lift and subsequent hard landing as result of the disengagement of a velcro strip at the top of the balloon's envelope.NTSB FTW95FA337Accident · 2 fatalField investigationFinal reportCessna 150M · Armorel, ARThe pilot's impairment of judgement and performance due to drugs which led to his failure to maintain airspeed and resulted in an inadvertent stall/spin. Factors were the pilot's overconfidence in personal ability and interpersonal relations.NTSB CHI95LA277Accident · Serious injuriesLimited investigationFinal reportPiper J3C-65 · New Prague, MNthe failure of the pilot to maintain adequate airspeed to permit control of the aircraft and to prevent an inadvertent stall. Contributing factors include gusty wind conditions and turbulence.NTSB CHI95LA273Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-201 · Wheeling, ILthe pilot's abrupt raising of the flaps during the attempted go-around and the resulting stall.NTSB CHI95LA270Accident · Minor injuriesLimited investigationFinal reportBell 47 · Arlington Hts, ILplot misjudged the flare. The factors included the pilot getting too close to the lead helicopter, allowing his airspeed to get too slow, and encountering settling with power.NTSB CHI95LA269Accident · Serious injuriesLimited investigationFinal reportBeech B24R · Tell City, INthe pilot initated the flight with an inadequate fuel supply and failed to add sufficient fuel en route which resulted in fuel exhaustion. A factor related to the accident was the rough terrain.NTSB ATL95LA157Accident · No injuriesLimited investigationFinal reportCessna 172H · Manteo, NCThe pilot's improper in-flight decision to touchdown at the mid-field point of the runway.NTSB ATL95LA156Accident · Serious injuriesLimited investigationFinal reportBeech A36 · Mckenzie, TNThe pilot's failure to comply with the performance data for the aircraft in his attempt to takeoff, downwind, from the short sod runway, with high density altitude, and with the aircraft weight in excess of the maximum gross weight allowed.NTSB ATL95LA155Accident · No injuriesLimited investigationFinal reportSchweizer 233A · Louisburg, NCThe flight instructor's improper in-flight planning and decision, in that he failed to maintain sufficient altitude to clear the trees surrounding the airport, and failed to take into consideration the high density altitude at the time of the accident.NTSB ATL95LA154Accident · Minor injuriesLimited investigationFinal reportPiper PA-46 · Dayton, TNThe pilot's failure to maintain control of the aircraft during landing.NTSB SEA95LA180Accident · No injuriesLimited investigationFinal reportMooney M20A · Rock Springs, WYThe pilot's failure to maintain control of the aircraft. Factors include the uneven runway condition, the information regarding the crowned condition not being disseminated by airport personnel, and the inadequate review/inspection of the condition by FAA…NTSB MIA95FA200Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Pulaski, TNFailure of the pilot to perform the before-takeoff checklist, and his failure to abort the takeoff due to inadequate acceleration. Contributing to the accident was an inadequate annual inspection by maintenance personnel for failure to safety the carburetor…NTSB FTW95LA347Accident · No injuriesLimited investigationFinal reportAyres S2R-T34 · Lake City, ARThe pilot's failure to maintain clearance with the transmission wires.NTSB FTW95LA336Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Cannon Afb, NMThe inadvertent stall. A factor was the pilot's premature retraction of the flaps.NTSB ATL95LA153Accident · No injuriesLimited investigationFinal reportYothment KOLB-FIRESTAR II · Lawrenceville, GAThe pilot's failure to maintain flying speed. A factor was the pilot's lack of familiarity with the aircraft.NTSB ATL95LA152Accident · Serious injuriesLimited investigationFinal reportAero Commander 100-180 · Ocracoke, NCA shattered windshield which precluded maintaining level flight due to increased aerodynamic drag.NTSB ANC95LA141Accident · No injuriesLimited investigationFinal reportShort Brothers SC.7 · Nikolai, AKIgnition of hazardous cargo (aviation fuel) by an exposed electrical wire, after leaking from a container of fuel that was being transported on the flight. Factors relating to the accident were: inadequate inspection of the airplane by company maintenance…NTSB ANC95LA137Accident · No injuriesLimited investigationFinal reportGuevremont Pitts Special S1C · Talkeetna, AKThe pilot's excessive application of rudder control, as he yawed the airplane to see ahead during the takeoff roll, which resulted in a loss of directional control and a subsequent ground swerve. Factors related to the accident were: the animal (moose) and…NTSB SEA95LA179Accident · No injuriesLimited investigationFinal reportCessna T188C · Mattawa, WAA partial loss of engine power for undetermined reasons.NTSB SEA95LA178Accident · No injuriesLimited investigationFinal reportCessna 210E · Bullfrog, UTThe right brake locking for undetermined reasons.NTSB MIA95TA199Accident · No injuriesFinal reportCessna 404 · Raiford, FLThe pilot's selection of unsuitable terrain for landing.NTSB MIA95LA201Accident · No injuriesLimited investigationFinal reportCessna 150L · Opa Locka, FLThe pilot-in-command's improper use of flaps during an attempted go-around.NTSB LAX95LA288Accident · No injuriesLimited investigationFinal reportCessna 152 · Camarillo, CAThe failure of the landing gear strut due to fatigue.