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 LAX93LA372Accident · No injuriesLimited investigationFinal reportCryder RV-6 · Ely, NVthe pilot's failure to maintain directional control of his conventional gear airplane after the failure of a main landing gear tire.NTSB LAX93LA371Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Kepuhi Molokai, HIA loss of main rotor RPM for undetermined reasons.NTSB FTW93LA273Accident · No injuriesLimited investigationFinal reportBell 206-L4 · Hurst, TXThe excessive flare and the control interference by the pilot undergoing instruction and inadequate supervision by the CFI. Factors were the pilot's failure to understand the instructor's directions due to his limited knowledge of the english language.NTSB FTW93LA271Accident · No injuriesLimited investigationFinal reportCessna 310Q · Edgewood, NMA propeller control unit failure, and loss of the pilot's option to feather the propeller. A factor was the lack of suitable terrain for a forced landing.NTSB FTW93FA274Accident · Serious injuriesField investigationFinal reportRobinson R22 Beta · Deming, NMThe pilot's inadequate preflight planning and preparation. Factors were high density altitude and the over gross weight condition of the aircraft.NTSB ATL93LA165Accident · No injuriesLimited investigationFinal reportCessna 150 · Sylvania, GAWas the pilot's failure to properly plan sufficient fuel for the flight which resulted in fuel exhaustion short of the destination airport.NTSB FTW93LA275Accident · No injuriesLimited investigationFinal reportKelm Zenair CH-701 · South Bend, ARThe engine power loss for undetermined reasons. A factor was the lack of available runway onto which the forced landing could be executed.NTSB FTW93GA269Accident · No injuriesFinal reportBell 206B · Wht Sands Mr, NMThe pilot's failure to land an adequate distance away from the unsecured parachute.NTSB BFO93FA189Accident · 3 fatalField investigationFinal reportPiper PA-24-250 · Akron, OHContinued flight by the pilot to an altitude that was not appropriate without supplemental oxygen, which resulted in a loss of aircraft control due to hypoxia and subsequently exceeding the design stress limits of the aircraft. Factors related to the accident…NTSB BFO93FA188Accident · 2 fatalField investigationFinal reportErcoupe 415-CD · Charles City, VAthe pilot exceeded the design stress limits of the airplane which resulted in an in-flight break-up.NTSB ATL93LA164Accident · No injuriesLimited investigationFinal reportCessna 210 · Smyrna, TNThe inadequate maintenance of the taxiway.NTSB SEA93LA208Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-150 · Salt Lake City, UTA power loss for undetermined reasons. Factors include a fence, an animal, and a ditch in the landing roll path.NTSB FTW93LA266Accident · No injuriesLimited investigationFinal reportBeech A36 · Houston, TXThe fuel leak which resulted from the mechanic's improper installation of the fuel line. A factor was the lead mechanic's inadequate post run up inspection.NTSB FTW93FA267Accident · 1 fatalField investigationFinal reportPiper PA-31P · San Antonio, TXFailure by the pilot-in-command to maintain VMC following takeoff. Factors were: partial loss of power to one engine for undetermined reason, and lack of total experience in aircraft type.NTSB CHI93LA380Accident · No injuriesLimited investigationFinal reportCessna 177B · Fayette, IAthe pilot-in-command's failure to refuel the airplane. A factor was a road sign and fuel exhaustion.NTSB CHI93FA378Accident · 2 fatalField investigationFinal reportAero Commander 690A · Lansing, MIwas the pilot-in-command not maintaining aircraft control during the intermittent operation of the electrically operated attitude gyro. Factor's associated with this accident are an fluctuating (intermittent) electrical system inverter and the…NTSB SEA93LA216Accident · No injuriesLimited investigationFinal reportLet Blanik L-13 · Clinton, MTTotal failure of the tow equipment.NTSB LAX93LA374Accident · No injuriesLimited investigationFinal reportErcoupe 415C · Columbia, CAthe pilot's improper use of the elevator control during the takeoff ground roll which resulted in a porpoise and nose gear collapse. A factor in the accident was the pilot's low total experience and lack of total time in type.NTSB CHI93LA379Accident · No injuriesLimited investigationFinal reportCessna 150M · Burlington, WIthe improper fuel calculations by the pilot-in-command. Factors were the pilot-in-command's not refueling and uphill terrain.NTSB CHI93LA376Accident · No injuriesLimited investigationFinal reportCessna 150H · Gary, INan improper climb airspeed established by the pilot-in-command after banner pickup.NTSB BFO93LA186Accident · 1 fatalLimited investigationFinal reportPiper PA-24-260 · Niagara Falls, NYThe pilot's failure to follow starting procedures and his inadequate preflight inspection by not removing the wheel chocks and the passenger not maintaining clearance from the propeller.NTSB ATL93LA163Accident · No injuriesLimited investigationFinal reportAerospatiale TB21 · Spruce Pine, NCThe pilot's inadequate inflight decision in delaying a go-around attempt and in attempting a go around with full flap extension.NTSB ATL93FA162Accident · 4 fatalField investigationFinal reportPiper PA-24-250 · Boone, NCThe pilot's improper preflight planning, his failure to retract the landing gear after departure, and his failure to maintain control of the aircraft. Factors in the accident were the high density altitude, and the mountainous terrain.NTSB ANC93LA189Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Rocky River, AKThe pilot misjudging his altitude on final approach.NTSB SEA93LA210Accident · No injuriesLimited investigationFinal reportWhite BD-5 · Helena, MTThe pilot's failure to maintain airspeed. The pilot's lack of experience in this make and model aircraft was a factor.NTSB MIA93WA201Accident · Minor injuriesForeign investigationCessna 172F · Long Island, Turks & Caicos IslandsNTSB LAX93LA370Accident · No injuriesLimited investigationFinal reportBeech A-36 · Firebaugh, CAthe CFI's inadequate supervision of the flight and his delay in taking remedial action; the dual student's premature liftoff and improper use of the flight controls. The high vegetation and soft terrain were factors in this accident.NTSB FTW93LA268Accident · No injuriesLimited investigationFinal reportCessna 182G · Baytown, TXThe fuel starvation power loss due to a sticking carburetor float. A factor was the lack of suitable terrain onto which a forced landing could be executed.NTSB BFO93LA187Accident · No injuriesLimited investigationFinal reportCessna 150B · Woodford, VAThe pilot misjudging his altitude and airspeed and not attaining the proper touchdown point resulting in the airplane exiting the runway and colliding with pine trees. Factors in this accident were: 1) the wet runway, 2) rain which resulted in poor braking…NTSB BFO93LA184Accident · No injuriesLimited investigationFinal reportCessna 172 · Emporia, VAThe pilot's selection of unsuitable terrain for a takeoff. A factor related to the accident was the pilot's delay in initiating an aborted takeoff.NTSB ANC93IA188Incident · No injuriesIncident investigationFinal reportBoeing 747-200 · Anchorage, AKForeign object damage to the compressor forward fan assembly as a result of the ingestion of a bird.NTSB SEA93LA213Accident · Serious injuriesLimited investigationFinal reportBell UH-1B · Detroit Lake, ORFailure of a second stage turbine wheel too low for a successful autorotation. Factors include a tree in the approach path.NTSB SEA93LA209Accident · Serious injuriesLimited investigationFinal reportAerospatiale SA 315B · Avery, IDThe pilot's improper use of the cyclic control.NTSB MIA93FA200Accident · 1 fatalField investigationFinal reportBeech C35 · Ocklawaha, FLFailure of a propeller blade for an undetermined reason, and failure of the pilot to maintain adequate airspeed, which resulted in an inadvertent stall. Factors related to the accident were: low pass performed by the pilot, and his possible impairment from…NTSB LAX93LA368Accident · No injuriesLimited investigationFinal reportCessna 172P · Phoenix, AZThe pilot's misjudging the landing flare. A physical problem may have contributed.NTSB LAX93FA369Accident · 2 fatalField investigationFinal reportRobinson R22 Beta · Wildomar, CAThe failure of the tail rotor blade after being struck by the pilot's knee board, and the failure of the pilot to adequately secure the knee board while in flight.NTSB SEA93LA212Accident · No injuriesLimited investigationFinal reportCessna 182RG · Vancouver, WAThe pilot's inadvertent landing gear retraction.NTSB SEA93LA207Accident · No injuriesLimited investigationFinal reportBell UH-1B · Pierce, IDSeparation of the 90 degree gearbox after fatigue failure of the gearbox attach bolts. Factors include hilly/mountainous terrain.NTSB MIA93LA199Accident · Minor injuriesLimited investigationFinal reportBoeing E75 · Deland, FLFailure of both pilots to maintain adequate visual lookout. Factors related to the accident were: the conflicting right traffic pattern procedures for landing that were briefed to the Boeing E75 pilot by the owner of the airstrip, and failure of both pilots…NTSB LAX93LA367Accident · Minor injuriesLimited investigationFinal reportRobinson R-22 Beta · Livermore, CAA partial engine power loss that resulted in a hard landing due to the engine primer system becoming unlocked.NTSB LAX93LA366Accident · 1 fatalLimited investigationFinal reportCessna 182H · Flagstaff, AZthe pilot's sudden incapacation due to a fatal heart attack.NTSB FTW93LA265Accident · No injuriesLimited investigationFinal reportPitts S1-T · Sherman, TXFailure to maintain visual lookout by the pilots in command of both aircraft.NTSB FTW93LA264Accident · Minor injuriesLimited investigationFinal reportFairchild M-62A · San Antonio, TXFuel starvation induced power loss due to the pilot's improper fuel tank selection and his failure to switch tanks after the power loss. A factor was the lack of suitable terrain onto which a forced landing could be executed.NTSB FTW93LA263Accident · 1 fatalLimited investigationFinal reportWsk Pzl Mielec M-18A Dromader · Frogmore, LAThe pilot's failure to maintain clearance with the powerline. A factor was the dusk light condition.NTSB BFO93LA185Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Wauseon, OHThe pilot's failure to compensate for the crosswind which resulted in loss of directional control during the flare/touchdown. A factor in the accident was the crosswind component.NTSB SEA93FA205Accident · 2 fatalField investigationFinal reportCessna 185A · De Borgia, MTThe pilot's poor in-flight planning/decision and his failure to maintain airspeed above a stall.NTSB MIA93LA202Accident · No injuriesLimited investigationFinal reportCessna 172M · Hollywood, FLInadvertent exceeding of vfe with the flaps extended by the student pilot while practicing maneuvers.NTSB LAX93LA375Accident · 2 fatalLimited investigationFinal reportBell 206B · Pacific Ocean (Pacific Ocean)a loss of engine power for undetermined reasons.NTSB LAX93LA365Accident · Minor injuriesLimited investigationFinal reportSnow 600-S2C · Surprise, AZThe pilot's improper inflight planning resulting in his airplane's encounter with wake turbulence.NTSB CHI93LA377Accident · No injuriesLimited investigationFinal reportLanceair 235M · Rockford, ILThe pilot-in-command delayed aborting the landing. Factors were a wet runway and the pilot-in-command's lack of recent experience in this type of airplane.