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.

NTSB ANC99LA135Accident · No injuriesLimited investigationFinal reportPiper PA-14 · Fairbanks, AKThe pilot's inadvertent stall during the landing flare.Aug 23, 1999 · N5402H · Substantial damageNTSB 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.Aug 23, 1999 · N5047Y · Substantial damageNTSB 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.Aug 22, 1999 · N116ML · Substantial damageNTSB 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.Aug 22, 1999 · N67198 · Substantial damageNTSB 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.Aug 22, 1999 · N3356B · Substantial damageNTSB 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.Aug 22, 1999 · N6243R · Substantial damageNTSB 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.Aug 22, 1999 · N5465F · Substantial damageNTSB 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.Aug 22, 1999 · N1630C · Substantial damageNTSB 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.Aug 22, 1999 · N5446X · Substantial damageNTSB SEA99LA147Accident · No injuriesLimited investigationFinal reportCessna 180A · Belgrade, MTClearance from objects was not maintained during taxiing. Factors include the pilot's inadequate visual lookout.Aug 21, 1999 · N5359D · Substantial damageNTSB 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.Aug 21, 1999 · N6268A · Substantial damageNTSB 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…Aug 21, 1999 · N6231V · Substantial damageNTSB 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.Aug 21, 1999 · N4394S · Substantial damageNTSB 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…Aug 21, 1999 · N88408 · Substantial damageNTSB 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.Aug 21, 1999 · N4809R · Substantial damageNTSB 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.Aug 21, 1999 · N8981J · Substantial damageNTSB 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.Aug 21, 1999 · N6249Z · Substantial damageNTSB DCA99WA091Accident · No injuriesForeign investigationHawker Siddeley 800XP · Istanbul, TürkiyeAug 21, 1999 · TCBHD · No damageNTSB CHI99LA308Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Granite City, ILLoss of power for undetermined reason(s) and the rough/uneven.Aug 21, 1999 · N90904 · Substantial damageNTSB 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…Aug 20, 1999 · N5378V · Substantial damageNTSB 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.Aug 20, 1999 · N6022Q · Substantial damageNTSB 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.Aug 20, 1999 · N2654W · Substantial damageNTSB 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.Aug 20, 1999 · N43404 · Minor damageNTSB 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.Aug 20, 1999 · N7277E · Substantial damageNTSB 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.Aug 20, 1999 · N4796B · Substantial damageNTSB 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…Aug 20, 1999 · N161BA · Substantial damageNTSB ANC99LA122Accident · No injuriesLimited investigationFinal reportde Havilland DHC-3T · Port Alsworth, AKThe pilot's inadvertent retraction of the trailing edge flaps during the takeoff run.Aug 20, 1999 · N888KA · Substantial damageNTSB 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.Aug 20, 1999 · N82905 · Substantial damageNTSB 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.Aug 19, 1999 · N2291L · Substantial damageNTSB NYC99LA207Accident · No injuriesLimited investigationFinal reportCessna 152 · Rockville, VAFuel exhaustion as a result of the pilot's improper in-flight planning/decision.Aug 19, 1999 · N49014 · Substantial damageNTSB NYC00WA172Accident · No injuriesForeign investigationLake LA-4-200 · Lake Puruvesi, FinlandAug 19, 1999 · N6187V · Substantial damageNTSB 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.…Aug 19, 1999 · N640AJ · DestroyedNTSB 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.Aug 19, 1999 · N9190G · Substantial damageNTSB 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…Aug 19, 1999 · N7021U · Minor damageNTSB 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.Aug 19, 1999 · N136MC · DestroyedNTSB NYC99WA205Accident · No injuriesForeign investigationCessna 180 · Quebec, CanadaAug 18, 1999 · N4535B · Substantial damageNTSB 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.Aug 18, 1999 · N1510Z · Substantial damageNTSB 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.Aug 18, 1999 · N854DF · Substantial damageNTSB 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…Aug 18, 1999 · N454DP · Substantial damageNTSB 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.Aug 18, 1999 · N4148B · DestroyedNTSB CHI99LA306Accident · No injuriesLimited investigationFinal reportPiper PA-34-220T · Salem, MOThe pilot in command misjudging the touchdown point.Aug 18, 1999 · N300JV · Substantial damageNTSB CHI99LA304Accident · No injuriesLimited investigationFinal reportCessna 152 · Omaha, NEthe student pilot's improper use of elevator control during the landing roll.Aug 18, 1999 · N869NE · Substantial damageNTSB ANC99FAMS2Accident · 1 fatalMissing aircraftFinal reportPiper PA-28R-200 · Chitina, AKUndetermined.Aug 18, 1999 · N56877 · DestroyedNTSB SEA99LA142Accident · No injuriesLimited investigationFinal reportCessna 152 · Kennewick, WAThe student pilot's inadequate compensation for gusty wind conditions. A contributing factor was gusty winds.Aug 17, 1999 · N6148Q · Substantial damageNTSB 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.Aug 17, 1999 · N97SP · DestroyedNTSB 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.Aug 17, 1999 · N7529 · Substantial damageNTSB 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.Aug 17, 1999 · N5416M · Substantial damageNTSB 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…Aug 17, 1999 · N63HJ · Substantial damageNTSB 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.Aug 17, 1999 · N206RR · Substantial damageNTSB 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.Aug 17, 1999 · N3004U · Substantial damage