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 ANC99LA135Accident · No injuriesLimited investigationFinal reportPiper PA-14 · Fairbanks, AKThe pilot's inadvertent stall during the landing flare.NTSB ANC99LA123Accident · Minor injuriesLimited investigationFinal reportBellanca 8GCBC · Wasilla, AKThe pilot's inadequate compensation for wind conditions. Factors associated with the accident were variable winds, and a downdraft.NTSB MIA99LA236Accident · Minor injuriesLimited investigationFinal reportMichael L. Luckey Sportsman 2 + 2 · Grand Junction, TNThe improper spoiler extension by the passenger following the bounced landing, which resulted in the hard landing and collapse of the left main landing gear.NTSB MIA99FA232Accident · 1 fatalField investigationFinal reportBeech C24R · Pickens, SCThe pilot's failure to properly preflight plan and prepare for the flight's fuel consumption resulting in engine loss of power due to fuel exhaustion and the subsequent inflight collision with trees.NTSB LAX99LA280Accident · No injuriesLimited investigationFinal reportPiper PA-18-18 · Eagleville, CAThe pilot's encounter with a thunderstorm induced downdraft, which resulted in a high rate of sink, at an altitude insufficient to provide for recovery prior to ground impact. The high density altitude was a factor in the accident.NTSB FTW99LA233Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Zachary, LAThe total loss of engine power due to fuel exhaustion resulting from the pilot's failure to refuel and his disorientation. Factors were the dusk light conditions and the lack of suitable terrain for the forced landing.NTSB FTW99LA231Accident · Minor injuriesLimited investigationFinal reportAlon A-2A · Cabot, ARThe missing engine oil filler cap which resulted in the loss of engine power as a result of oil starvation. Factors were the pilot's improper aircraft preflight inspection and the lack of suitable terrain for the forced landing.NTSB DEN99LA153Accident · No injuriesLimited investigationFinal reportCessna 180 · Heber City, UTThe stripped threads and subsequent separation of the left hydraulic brake line leading to fluid loss and the pilot's inability to maintain directional control.NTSB ANC99LA118Accident · No injuriesLimited investigationFinal reportCessna 206 · Anaktuvuk Pass, AKThe pilot's continued flight into adverse weather conditions after becoming lost/disoriented. Factors in the accident were rising terrain, a blind/box canyon, and weather conditions consisting of clouds, rain, and fog.NTSB SEA99LA147Accident · No injuriesLimited investigationFinal reportCessna 180A · Belgrade, MTClearance from objects was not maintained during taxiing. Factors include the pilot's inadequate visual lookout.NTSB NYC99LA208Accident · 2 fatalLimited investigationFinal reportKlotz Kolb Mark III · Scott, OHThe pilot's failure to maintain airspeed, which resulted in a stall, after he experienced a loss of lift due to an improperly installed gap seal.NTSB MIA99LA233Accident · No injuriesLimited investigationFinal reportCessna 172RG · Miami, FLThe delay by the pilot-in-command to extend the gear resulting in collapse of the main landing gear after touchdown. Factors in the accident were the inoperative gear warning system associated with the throttle due to the broken wire at the throttle…NTSB MIA99LA231Accident · Serious injuriesLimited investigationFinal reportAlson g. Siler CH-701 · Mount Pleasant, NCThe failure of the pilot to apply sufficient right rudder input during the go-around following a bounced landing and his failure to maintain runway alignment resulting in the in-flight collision with trees 100-150 yards to the left of the runway.NTSB LAX99LA279Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Livermore, CAThe failure of the no. 3 cylinder exhaust valve due to the operator's failure to adhere to recommended overhaul periods set by the engine manufacturer. A factor in the accident was the operator's failure to comply with the manufacturer's mandatory service…NTSB LAX99LA278Accident · No injuriesLimited investigationFinal reportCessna TR182 · S. Lake Tahoe, CAThe pilot's failure to verify the landing gear was in the extended position. A factor in the accident was gear warning system's unresolved discrepancies.NTSB FTW99LA230Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Weatherford, TXThe loss of engine power during the initial takeoff climb for an undetermined reason. A factor was the lack of suitable terrain for the forced landing.NTSB DEN99LA152Accident · Serious injuriesLimited investigationFinal reportPiper PA-25 · Salida, COAn inadvertent stall during an aborted landing. A factor was the pilot's selection of the wrong runway for landing.NTSB DCA99WA091Accident · No injuriesForeign investigationHawker Siddeley 800XP · Istanbul, TürkiyeNTSB CHI99LA308Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Granite City, ILLoss of power for undetermined reason(s) and the rough/uneven.NTSB LAX99LA277Accident · No injuriesLimited investigationFinal reportCessna T210L · Byron, CAThe failure of the operator's maintenance personnel to properly torque the cylinder and engine case through bolts during the replacement of five cylinders, which led to the spinning of the No. 2 main bearing and the resultant oil starvation induced…NTSB LAX99LA276Accident · Serious injuriesLimited investigationFinal reportMooney M20E · Lakeport, CAThe failure of engine shop maintenance personnel to tighten the fuel line fitting during assembly of the engine, and failure of the installing maintenance personnel to detect and tighten the loose fitting during the engine installation and annual inspection.NTSB LAX99FA275Accident · 2 fatalField investigationFinal reportMooney M20E · Las Vegas, NVThe pilot's steep turn at low altitude that resulted in an accelerated stall while in the landing configuration, leading to a loss of control and subsequent ground impact.NTSB FTW99LA232Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-151 · Houston, TXThe failure of the pilot to maintain clearance with the person (the airport manager) walking on the taxiway and the inadequate visual lookout by the airport manager. A factor was the airport manager's diverted attention to the aircraft accident.NTSB FTW99LA229Accident · Serious injuriesLimited investigationFinal reportCessna 182B · Houston, TXThe loss of engine power as a result of fuel starvation due to the pilot's improper fuel management.NTSB DEN99LA164Accident · No injuriesLimited investigationFinal reportCessna 180 · Columbus, NMFuel exhaustion because the pilot issued instructions that the fuel tanks not be filled to capacity. A factor was the unsuitable terrain on which to make a forced landing.NTSB CHI99LA307Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Garrett, INthe pilot's improper inflight planning/decision to land and takeoff on the airstrip which was unsuitable and closed, and the pilot's failure to attain clearance with the trees during the takeoff initial climb. Factors associated with the accident were the…NTSB ANC99LA122Accident · No injuriesLimited investigationFinal reportde Havilland DHC-3T · Port Alsworth, AKThe pilot's inadvertent retraction of the trailing edge flaps during the takeoff run.NTSB ANC99LA121Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Sleetmute, AKThe pilot's selection of an unsuitable takeoff area, which resulted in the airplane colliding with vegetation, knocking the gascolator off the airplane, and fuel starvation of the engine.NTSB SEA99FA144Accident · 1 fatalField investigationFinal reportBeech F33A · White Swan, WAInadequate preflight planning/preparation and low airspeed. A dirt embankment, soft runway, and an excessive takeoff weight were factors.NTSB NYC99LA207Accident · No injuriesLimited investigationFinal reportCessna 152 · Rockville, VAFuel exhaustion as a result of the pilot's improper in-flight planning/decision.NTSB NYC00WA172Accident · No injuriesForeign investigationLake LA-4-200 · Lake Puruvesi, FinlandNTSB MIA99FA230Accident · 1 fatalField investigationFinal reportCessna 210L · Tampa, FLThe failure of the pilot to follow procedures and directives established by the operator for his failure to fuel the airplane after landing following the first leg. Contributing to the accident was the total loss of engine power due to fuel exhaustion.…NTSB LAX99TA274Accident · No injuriesFinal reportAir Tractor AT-802A · Elko, NVThe pilot's failure to maintain an adequate terrain/obstacle clearance altitude margin while engaged in fire fighting operations.NTSB LAX99FA273Accident · Serious injuriesField investigationFinal reportBalloon Works Firefly 11 · Cave Creek, AZAn unforecast encounter with a low level microburst that resulted in a distortion of the balloon envelope, an excessive outflow of hot air (loss of lift), creating an excessive rate of descent that was beyond the performance capability of the balloon to…NTSB CHI99LA303Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Seward, NEthe pilot's failure to maintain clearance from the power line. A factor relating to this accident was the power line.NTSB NYC99WA205Accident · No injuriesForeign investigationCessna 180 · Quebec, CanadaNTSB MIA99LA229Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-402 · Holly Bluff, MSThe pilot's failure to maintain visual separation between his airplane and a tree while maneuvering during aerial application and the subsequent collision with the tree and the terrain. A factor in the accident was the sunglare on the airplane's windscreen.NTSB LAX99LA264Accident · Minor injuriesLimited investigationFinal reportDiamond Aircraft Industries Katana DA 20-A1 · San Carlos, CAThe release of the aircraft's left canopy latch following takeoff resulting in the subsequent opening of the canopy in flight. The opened canopy resulted in a degradation of aircraft control and the subsequent hard landing.NTSB LAX99FA272Accident · No injuriesField investigationFinal reportBeech BH 125-600A · Las Vegas, NVthe complete failure of all hydraulic systems due to the effects of a main gear tire disintegration on takeoff. Also causal was the manufacturer's inadequate design of the wheel wells, which did not comply with applicable certification regulations, and the…NTSB DEN99LA151Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Albuquerque, NMThe pilot's failure to follow published procedures in operating the aircraft. A factor was partial failure of the electrical system.NTSB CHI99LA306Accident · No injuriesLimited investigationFinal reportPiper PA-34-220T · Salem, MOThe pilot in command misjudging the touchdown point.NTSB CHI99LA304Accident · No injuriesLimited investigationFinal reportCessna 152 · Omaha, NEthe student pilot's improper use of elevator control during the landing roll.NTSB ANC99FAMS2Accident · 1 fatalMissing aircraftFinal reportPiper PA-28R-200 · Chitina, AKUndetermined.NTSB SEA99LA142Accident · No injuriesLimited investigationFinal reportCessna 152 · Kennewick, WAThe student pilot's inadequate compensation for gusty wind conditions. A contributing factor was gusty winds.NTSB NYC99GA197Accident · Minor injuriesFinal reportBell 407 · Georgetown, DEThe pilot's improper preflight evaluation of the weather, which resulted in inadvertent flight into IMC. Factors were the fog, and night conditions.NTSB MIA99LA227Accident · No injuriesLimited investigationFinal reportLet Blanik L-13 · Perry, SCan in-flight collision with the ground due to inadequate liftoff airspeed, and the pilot's improper use of flaps, which resulted in too low of an altitude to sustain flight.NTSB MIA99LA225Accident · No injuriesLimited investigationFinal reportCessna 152 · Ocala, FLA misjudged flare and the failure of the student pilot to use the proper recovery technique for a bounced landing, allowing the airplane to commence a porpoise, and the eventual collapse of the nose landing gear.NTSB MIA99FA226Accident · No injuriesField investigationFinal reportCanadair CL-600 · Fort Lauderdale, FLThe failure of the flight crew to main directional control of the airplane after landing, resulting in the airplane going off the side of the runway and colliding with a taxiway sign, collapsing the nose landing gear, and causing substantial damage to the…NTSB LAX99LA271Accident · No injuriesLimited investigationFinal reportCessna TU 206G · Clear Lake, CAThe fracture and separation of the front left pontoon attach point due to corrosion. The inability of the area to be inspected was a factor in the accident.NTSB LAX99LA268Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Sacramento, CAFuel exhaustion due to the pilot's failure to ensure that sufficient fuel was on board to complete the flight, and, the flight instructor's inadequate supervision of the flight.