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 MIA95WA143Accident · No injuriesForeign investigationBoeing B-747-238 · Panama City, PanamaNTSB LAX95LA201Accident · Serious injuriesLimited investigationFinal reportCessna 180F · Cartago, CAthe pilot's inflight decision to attempt a low pass over a mountain airstrip at a high density alitude atmospheric condition, and, his failure to retract the flaps during the climb-out from the pass. The rising mountainous terrain surrounding the landing…NTSB FTW95LA233Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Collegeport, TXThe pilot's improper planning/decision by attempting to takeoff in an overweight condition from an 1,800 foot runway. Factors were the wet and soft condition of the runway.NTSB CHI95LA172Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Dawson, MNthe pilot's selection of unsuitable terrain for takeoff, and his failure to maintain directional control of the airplane on takeoff. A factor in the accident was the tall grass.NTSB CHI95LA170Accident · No injuriesLimited investigationFinal reportAirbus Industrie A-320-211 · St Paul, MNthe captain's not maintaining crew/group coordination. Factors were the captain's diverted attention and his not maintaining visual separation.NTSB CHI95LA167Accident · No injuriesLimited investigationFinal reportPiper PA-16 · Williston, NDThe failure of the pilot to maintain directional control on takeoff. The soft condition of the field was a factor.NTSB CHI95LA166Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-161 · Valparaiso, INThe pilot's improper execution of the ILS approach. Factors related to the accident were the fog and the pilot's lack of total flight time in actual instrument conditions.NTSB ATL95LA103Accident · Serious injuriesLimited investigationFinal reportMooney M20E · Moncks Corner, SCThe pilot's failure to properly calculate the fuel required and his fuel consumption for the flight.NTSB ANC95TA067Accident · No injuriesFinal reportPiper PA-18-150 · Sand Point, AKThe premature castoring of the tailwheel steering mechanism. A factor associated the accident is the added degree of difficulty in handling airplanes equipped with oversize 'tundra' tires.NTSB ANC95FA063Accident · Serious injuriesField investigationFinal reportPiper J3C-65 · Palmer, AKThe pilot's inadvertent stall. A factor in the accident was the pilot's emotional reaction to the vehicle travelling through his yard.NTSB MIA95LA144Accident · 1 fatalLimited investigationFinal reportPiper PA-32-260 · Vieques, PRUndetermined.NTSB FTW95TA228Accident · No injuriesFinal reportBell 206B-III · Meeker, COFailure by the pilot to maintain control of the aircraft during landing. A factor was soft terrain.NTSB FTW95LA229Accident · No injuriesLimited investigationFinal reportCessna 182K · Alamosa, COFailure of the pilot to maintain directional control during the landing roll, which resulted in a ground swerve and collision with a taxiway sign. Factors relating to the accident were: the unfavorable (gusty/quartering) wind condition, and the taxiway sign's…NTSB ATL95LA102Accident · Serious injuriesLimited investigationFinal reportBurchfield Rose Parakeet · Tuscaloosa, ALThe pilot's inadequate preflight. Factors in the accident were the previous wing damage, and the obstruction of air flow over the aileron.NTSB SEA95LA110Accident · 1 fatalLimited investigationFinal reportGarlick TH-1L · Umpqua, ORThe pilot's failure to maintain clearance with a tree, resulting in a tail rotor blade strike on the tree which disabled the tail rotor. Contributing to the accident was the 150-foot-high rock bluff.NTSB SEA95FA111Accident · 3 fatalField investigationFinal reportAero Commander 680 · North Bend, ORThe pilot initiating flight into weather conditions beyond what he was capable of handling. The pilot's overconfidence in his personal ability and the low ceiling were factors in the accident.NTSB NYC95LA131Accident · Serious injuriesLimited investigationFinal reportTaylorcraft BC-12 · Geneseo, NYThe pilot's inadequate preflight inspection, which failed to detect water-contaminated fuel which resulted in the loss of engine power. Also causal was the pilot's failure to maintain airspeed during the forced landing, which resulted in the inadvertent…NTSB NYC95FA129Accident · 2 fatalField investigationFinal reportCessna T210N · Monkton, VTfailure of the pilot to maintain sufficient altitude or clearance from mountainous terrain. Factors related to the accident were: loss of electrical power for undetermined reason(s), darkness, and the mountainous terrain.NTSB MIA95FA141Accident · 2 fatalField investigationFinal reportPiper PA-23-250 · Opa-Locka, FLA loss of engine power due to water contamination of the fuel, the pilot's inadequate preflight, and his intentional operation of the airplane with known deficiencies in equipment which resulted in an inadvertent stall at an altitude inadequate for recovery.…NTSB LAX95LA203Accident · No injuriesLimited investigationFinal reportBeech B23 · Mariposa, CAthe pilot's premature liftoff and his failure to attain and maintain sufficient airspeed during the intial climb which resulted in an inadvertent stall/mush back onto the runway. The pilot's failure to maintain directional control as the aircraft touched down…NTSB LAX95LA200Accident · No injuriesLimited investigationFinal reportEurocopter AS-355F1 · Lost Hills, CAthe pilot's in-flight loss of control and failure to maintain a proper descent rate due to spatial disorientation and lack of visual cues during a dark, night approach to a unimproved landing zone, and his failure to initiate a go-around when he first lost…NTSB FTW95LA223Accident · No injuriesLimited investigationFinal reportCessna 120 · College Station, TXThe pilot's inability to maintain directional control after encountering wake turbulence from a landing airplane. A factor was the tailwind.NTSB CHI95LA163Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · E. Grand Forks, MNThe pilot's failure to maintain clearance with the wires.NTSB CHI95LA162Accident · No injuriesLimited investigationFinal reportBeech C23 · Lake Ann, MIthe pilot's inadequate preflight planning/preparation and improper short field landing procedures. Factors associated with the accident were the wet terrain, a tailwind, and the pilots lack of recent experience.NTSB BFO95LA054Accident · No injuriesLimited investigationFinal reportCessna 172N · Head Waters, VAthe pilot's poor planning/decision making in the attempted departure. Contributing factors are the wet, recently mowed grass airstrip, and the embankment/downhill grade encountered during the aborted takeoff.NTSB ATL95LA104Accident · No injuriesLimited investigationFinal reportAmerican AA-1 · Rock Hill, SCAn inoperative left main wheel brake that resulted in a loss of directional control. A factor was the wet, grass runway.NTSB NYC95LA130Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Ashland, VAa loss of engine power due to a subsurface fatigue crack in the crankshaft which led to failure of the crankshaft.NTSB NYC95LA128Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Bluffton, OHan improperly planned approach and touchdown, which resulted in an loss of directional control at touchdown, with the airplane departing the runway, and striking a ravine.NTSB MIA95LA244Accident · No injuriesLimited investigationFinal reportCessna 172N · Madison, MSThe pilot's improper flare and/or improper recovery from a bounced landing.NTSB MIA95FA142Accident · 1 fatalField investigationFinal reportBellanca 17-30A · Corinth, MSThe pilots decision to continue his VFR flight into instrument meteorological conditions after being advised that VFR flight should not be attempted, resulting in spatial disorientation and loss of control. Factors in the accident were: the pilot's…NTSB BFO95LA056Accident · No injuriesLimited investigationFinal reportKnoll-Bensen B-80 · Germansville, PAthe private pilot's misjudged flare, which resulted in a hard landing.NTSB ANC95LA062Accident · No injuriesLimited investigationFinal reportAerospatiale AS-350-B2 · Skagway, AKThe pilot's selection of unsuitable terrain for landing. Factors in the accident were the uneven and icy terrain.NTSB SEA95LA109Accident · Minor injuriesLimited investigationFinal reportBoeing A75N1 · Rawlins, WYThe pilot's failure to maintain a proper climb rate. Factors contributing to the accident were the high density altitude and the rising terrain.NTSB LAX95LA199Accident · 3 fatalLimited investigationFinal reportPiper PA-28-151 · Honolulu, HIfuel exhaustion resulting from pilot's inadequate preflight fuel planning for the over water flight.NTSB FTW95LA239Accident · No injuriesLimited investigationFinal reportBell 47G-5 · Falfurrias, TXInadvertent installation of an unapproved part (tail rotor gear/drive assembly), that became excessively worn since it did not conform to the manufacturer's specification, resulting in failure of the associated tail rotor bearing (also an unapproved part),…NTSB FTW95FA222Accident · 4 fatalField investigationFinal reportPiper PA-28-180 · Byers, COThe pilot's continued VFR flight into instrument meteorological conditions and the subsequent loss of control due to spatial disorientation. Factors were the low ceilings, the dark night conditions, and the pilot's lack of total instrument time.NTSB CHI95LA160Accident · 1 fatalLimited investigationFinal reportWeatherly 201C · Clarks, NEa partial failure of the engine supercharger.NTSB CHI95FA161Accident · Serious injuriesField investigationFinal reportBeech A35 · Downers Grove, ILfuel contamination (water), and the pilot's inadequate aircraft preflight. A factor was trees.NTSB SEA95LA108Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301A · Terreton, IDThe pilot's failure to maintain an adequate altitude to overcome the downdraft. The downdraft was a factor.NTSB NYC95FA127Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Jefferson Twp, OHThe pilot's failure to maintain control of the airplane which resulted in a collision with terrain during a descent.NTSB FTW95LA224Accident · 2 fatalLimited investigationFinal reportCornelius LONG-EZ · Clines Corner, NMThe pilot flying the aircraft into IMC conditions at an altitude which was inadequate to clear surrounding terrain. Factors were low ceiling and fog.NTSB ATL95FA101Accident · 1 fatalField investigationFinal reportPiper J3C-65 · Greenville, SCThe pilot's failure to maintain flying speed. A factor was his failure to reposition the elevator trim.NTSB ANC95LA061Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Galena, AKThe water contaminating the fuel and the pilot's inadequate preflight which failed to eliminate the water from the fuel system.NTSB ANC95LA060Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Koliganek, AKThe pilot's failure to attain the proper approach and landing speed, not maintaining directional control, and his inadequate remedial action(s). A factor in the accident was the loose objects in the landing area.NTSB SEA95LA113Accident · No injuriesLimited investigationFinal reportCessna 180 · Phillipsburg, MTThe failure of the dual student to maintain directional control during the bounced landing, and the failure of the certified flight instructor to take adequate remedial action and recover from the loss of directional control. A factor contributing to the…NTSB MIA95LA140Accident · No injuriesLimited investigationFinal reportMoncrief Zodiac 601 · Fernandina Bch, FLThe failure of maintenance personnel to adequately torque the propeller bolts during the last inspection resulting in the bolt failures and the loss of the propeller.NTSB MIA95LA139Accident · No injuriesLimited investigationFinal reportCessna 182A · Vero Beach, FLTotal loss of engine power for undetermined reasons while on final approach to land and unsuitable terrain encountered during the landing roll.NTSB MIA95LA138Accident · No injuriesLimited investigationFinal reportNorth American T-28A · Arcadia, FLLoss of engine power due to separation of 3 connecting rods from the master rod for undetermined reasons(s).NTSB LAX95FA198Accident · 4 fatalField investigationFinal reportCessna 172N · Lovelock, NVthe pilot's intentional flight at low altitude and subsequent collision with transmission wires during dusk light conditions.NTSB FTW95LA220Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Stephenville, TXThe pilot's failure to execute a go-around. Factors were the excessive airspeed and high glidepath during the approach.