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 FTW01LA090Accident · No injuriesLimited investigationFinal reportMooney M20J · Pecos, TXthe pilot's failure to obtain a proper glide path during landing, which resulted in the airplane's impact with terrain short of the runway. Contributory factors were the open baggage door and the pilot's diverted attention to the open door.NTSB DCA01MA034Accident · 18 fatalClass 1 · MajorFinal reportGrumman Gulfstream III · Aspen, COthe flight crew's operation of the airplane below the minimum descent altitude without an appropriate visual reference for the runway. Contributing to the cause of the accident were the Federal Aviation Administration's (FAA) unclear wording of the March 27,…NTSB ATL01LA044Accident · Minor injuriesLimited investigationFinal reportPiper PA-24 · Cross City, FLThe fracture of the crankshaft assembly that resulted in a total loss of engine power.NTSB ATL01LA042Accident · Serious injuriesLimited investigationFinal reportPiper PA-18A-150 · Niceville, FLA loss of engine power for undetermined reasons.NTSB LAX01LA130Accident · No injuriesLimited investigationFinal reportPiper PA18-150 · Holbrook, AZFailure of the rudder lower hinge attach point resulting in a loss of rudder control and steerable tailwheel control. A factor was the crosswind condition.NTSB LAX01FA129Accident · 3 fatalField investigationFinal reportCessna 172N · Santa Monica, CAthe pilot's loss of airplane control while maneuvering due to spatial disorientation. Contributing factors were the dark night, the marine cloud layer that restricted the pilot's cruising altitude, and the pilot's lack of familiarity with nighttime flight…NTSB DEN01LA079Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Las Vegas, NMthe pilot's failure to maintain directional control during landing roll. Factors were weather evaluation by the pilot and rough terrain off the side of the runway.NTSB DEN01LA078Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Grand Junction, COFailure by the pilot to maintain directional control during takeoff roll. A factor was a crosswind.NTSB ANC01LA044Accident · Serious injuriesLimited investigationFinal reportPiper PA-12 · Cooper Landing, AKThe pilot's continued VFR flight into instrument metrological conditions during cruise flight. Factors associated in the accident were low ceilings, whiteout conditions, and snow-covered terrain.NTSB IAD01LA044Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Hammonton, NJpilot's failure to maintain directional control during the landing roll-out. A factor was the crosswind.NTSB CHI01LA109Accident · Serious injuriesLimited investigationFinal reportCessna 414 · Minneapolis, MNThe pilot not maintaining the proper airspeed during the circling approach, the inadvertent stall and the subsequent loss of control. Factors were the pilot's decision to continue the approach in weather conditions below the approach/landing minimums, the…NTSB ANC01LA052Accident · No injuriesLimited investigationFinal reportCessna 180 · Iliamna, AKThe pilot's selection of an unsuitable landing area. A factor associated with the accident was uneven terrain.NTSB SEA01LA069Accident · No injuriesLimited investigationFinal reportCessna 180H · Coeur d'Alene, IDThe pilot's failure to maintain aircraft control during the aborted takeoff. A factor was gusty crosswinds.NTSB MIA01LA105Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Dyer, TNThe improper installation of the main landing gear tire (pinched tube) by company maintenance personnel resulting in a total loss of air pressure in-flight, loss of directional control on landing roll, and subsequent nose down.NTSB DEN01LA076Accident · No injuriesLimited investigationFinal reportBeech 95-B55B (T42A) · Watkins, COAn inadvertent landing gear retracted landing by the CFI during an instructional flight conducting a touch-and-go landing.NTSB DCA01WA032Incident · No injuriesForeign investigationBoeing 767-300ER · Paris, FranceNTSB DEN01FA075Accident · 1 fatalField investigationFinal reportSocata TBM 700 · Englewood, COthe pilot's spatial disorientation, which led to his failure to maintain aircraft control. A contributing factor was the pilot's decision to intentionally fly into known adverse weather that consisted of low ceilings, obscuration, and ice fog.NTSB SEA01WA073Accident · 3 fatalForeign investigationPiper PA-28-181 · KagawaPrefectur, JapanNTSB FTW01LA086Accident · No injuriesLimited investigationFinal reportCartercopters Cartercopter · Olney, TXthe pilot's failure to maintain rotor rpm, which resuted in the main rotor contacting the tail during landing.NTSB DEN01LA077Accident · No injuriesLimited investigationFinal reportBell UH-1H · Zuni, NMa hard landing due to the pilot's failure to maintain aircraft control during autorotation/flare. A factor was the total loss of engine power due to mechanical failure.NTSB DCA01WA035Incident · No injuriesForeign investigationBoeing B-737-700 · Riyahd, Saudi ArabiaNTSB NYC01FA089Accident · 1 fatalField investigationFinal reportCessna 182Q · Dixon, KYThe pilot's failure to maintain adequate clearance while maneuvering, which resulted in an in-flight collision with trees.NTSB MIA01WA138Accident · 20 fatalForeign investigationde Havilland DHC-6-300 · Saint Barthelem, GuadeloupeNTSB FTW01LA085Accident · No injuriesLimited investigationFinal reportCessna 172RG · Waco, TXthe failure of the number four cylinder exhaust valve which resulted in a total loss of engine power during cruise. A contributing factor was the lack of suitable terrain for the forced landing.NTSB SEA01LA067Accident · No injuriesLimited investigationFinal reportRepublic RC-3 · Carr Inlet, WAFatigue fracture of the propeller attaching bolts resulting in the total separation of the propeller assembly from the crankshaft flange.NTSB NYC01LA088Accident · Serious injuriesLimited investigationFinal reportBell 206 L-1 · Seneca Falls, NYthe loss of a bolt in a Thomas coupling on the tail rotor drive shaft, for undetermined reasons, during climb, while operating over unsuitable terrain.NTSB LAX01LA128Accident · No injuriesLimited investigationFinal reportCessna 305A · Winslow, AZThe student's inadvertent restriction of the rudder pedal's movement during landing rollout precipitated the loss of directional control and ground loop. A finding was that remedial action by the CFI was not possible due to the student’s control interference.NTSB FTW01TA084Accident · No injuriesFinal reportCessna 152 · Antlers, OKfuel exhaustion in cruise flight due to the pilot's delay in refueling. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW01LA089Accident · No injuriesLimited investigationFinal reportAviat A-1B Husky · Odessa, TXthe pilot's failure to maintain directional control during landing, which resulted in a ground loop.NTSB ATL01LA041Accident · Serious injuriesLimited investigationFinal reportBoeing 727-200 · Memphis, TNThe Powerback Coordinator's failure to follow powerback procedures which resulted in jet blast injuries to the wing walker. A factor was the stuck wheel chock.NTSB NYC01WA090Accident · No injuriesForeign investigationPiper PA-31-350 · Orleans, FranceNTSB MIA01LA104Accident · Serious injuriesLimited investigationFinal reportPiper PA-25-235 · Bainbridge, GAThe pilot's failure to maintain a visual lookout while maneuvering during a agricultural run, and inadvertent descent with a known sun glare resulting in an in-flight collision with terrain.NTSB LAX01FA127Accident · No injuriesField investigationFinal reportAgusta A109A · Hanapepe, Kauai, HIthe pilot's misjudged flare during an autorotation, which resulted in a hard landing. A contributing factor was the check airman's failure to demonstrate a stuck pedal maneuver prior to assigning the procedure to the pilot.NTSB FTW01LA087Accident · No injuriesLimited investigationFinal reportBell 47G2 · Ardmore, OKthe loss of tail rotor control during maneuvering resultant from the failure of the tail rotor drive shaft coupling due to a stripped thread which allowed the grease lubricating the shaft to leak out. A factor was the lack of suitable terrain for the forced…NTSB DEN01FA074Accident · 2 fatalField investigationFinal reportVangilder Christen Eagle II · Ogden, UTthe flight instructor's failure to maintain aircraft control while maneuvering and the subsequent inadvertent stall/spin. A contributing factor was the flight instructor's lack of familiarity with the airplane.NTSB ANC01LA042Accident · No injuriesLimited investigationFinal reportCessna 180 · Soldotna, AKThe private pilot/student's inadequate compensation for crosswind conditions and subsequent loss of directional control of the airplane during a touch and go, and the instructor pilot's inadequate supervision of the flight. Factors in the accident were a…NTSB SEA01LA066Accident · Serious injuriesLimited investigationFinal reportMooney M20A · Gresham, ORThe pilot's inadequate decision in which he failed to refuel while en route, resulting in fuel exhaustion and loss of engine power.NTSB LAX01LA143Accident · No injuriesLimited investigationFinal reportBeech C35 · Fullerton, CAThe premature retraction of the landing gear and the failure of the CFI to properly supervise the flight.NTSB LAX01LA125Accident · No injuriesLimited investigationFinal reportRobinson R22B · Long Beach, CAFailure of the CFI to adequately monitor the flight, which resulted in a low airspeed autorotation and hard landing.NTSB LAX01LA124Accident · No injuriesLimited investigationFinal reportCessna 150G · San Diego, CAThe student pilot's poor inflight planning/judgement to continue a flight into IFR conditions and not divert to an airport operating under VFR conditions. Factors were the pilot's misunderstanding of his flight limitations, special VFR, and not obtaining a…NTSB SEA01FA064Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Greenwater, WAFailure to maintain clearance from mountainous terrain.NTSB LAX01LA123Accident · No injuriesLimited investigationFinal reportCessna 172RG · Stanford, CAFailure of company maintenance personnel to properly install and safety wire the oil filter, which subsequently lead to a loss of engine power.NTSB LAX01LA122Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Gila Bend, AZFailure of the CFI to properly supervise the flight and the failure of the dual studen to maintain flying airspeed. A contributing factor was the wind shear encountered.NTSB IAD01FA038Accident · 1 fatalField investigationFinal reportPiper PA-28-RT201 · Manassas, VAThe pilot's spatial disorientation due to a night visual illusion. A factor was the dark night condition.NTSB FTW01LA081Accident · 1 fatalLimited investigationFinal reportSikorsky SK-76A · Ec 270the passenger's inadvertent encounter with the rotating main rotor blades.NTSB DEN01LA073Accident · No injuriesLimited investigationFinal reportCessna 340 · Alamosa, COThe in-flight collision with a large bird during downwind approach for landing.NTSB CHI01LA107Accident · No injuriesLimited investigationFinal reportCessna 172K · Holland, MIThe pilot failed to maintain directional control of the airplane. Factors included the soft ground and the runway lights.NTSB LAX01LA121Accident · Minor injuriesLimited investigationFinal reportSchweizer 269C · Ojai, CAA loss of engine power for undetermined reasons.NTSB DEN01LA072Accident · No injuriesLimited investigationFinal reportCessna 182A · Richfield, UTloss of engine power during cruise as a result of fuel exhaustion due to the pilots failure to refuel. Contributing factors were the pilots inadequate aircraft preflight and the unsuitable terrain for a forced landing.NTSB DCA01MA031Accident · No injuriesMajor investigationFinal reportEmbraer EMB-120 · West Palm Beach, FLthe failure of the flight crew to maintain airspeed during an encounter with severe icing conditions, which resulted in an inadvertent stall, loss of control, and structural damage to the airplane.