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 FTW99LA238Accident · Serious injuriesLimited investigationFinal reportBurkhart Grob 103C · San Antonio, TXThe pilot's failure to attain proper runway alignment of the glider resulting in failure to maintain obstacle clearance. A factor was the high density altitude.Aug 28, 1999 · N103MS · Substantial damageNTSB DEN99LA155Accident · Minor injuriesLimited investigationFinal reportNorth American SNJ-4 (AT-6) · Mack, COThe pilot misjudging his distance and altitude from the runway. A factor was the tall crops.Aug 28, 1999 · N7011C · Substantial damageNTSB CHI99LA330Accident · No injuriesLimited investigationFinal reportBoeing Stearman E75 · Sparta, ILThe pilot's decision not to use all of the available. A factor to the accident was the ditch.Aug 28, 1999 · N4752V · Substantial damageNTSB CHI99LA318Accident · No injuriesLimited investigationFinal reportAeronca 11BC · Watervliet, MIthe pilot not maintaining aircraft control during takeoff, and the pilot not correcting for the porpoise.Aug 28, 1999 · N9404E · Substantial damageNTSB CHI99LA317Accident · No injuriesLimited investigationFinal reportAyres S-2R · Brooten, MNthe compressor impeller failure and the unsuitable terrain for landing encountered by the pilot.Aug 28, 1999 · N8417V · Substantial damageNTSB CHI99LA316Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Osceola, WIthe pilot's improper preflight decision to attempt a takeoff with one engine inoperative.Aug 28, 1999 · N6592Y · Substantial damageNTSB CHI99LA313Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Pawnee City, NEThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall.Aug 28, 1999 · N5535U · Substantial damageNTSB ANC99LA127Accident · No injuriesLimited investigationFinal reportMaule M-7 · Kotzebue, AKAn in-flight collision with a bird.Aug 28, 1999 · N770AS · Substantial damageNTSB MIA99WA240Accident · 2 fatalForeign investigationRobinson R22B · Cornakelly, IrelandAug 27, 1999 · EIMAC · DestroyedNTSB MIA99LA239Accident · No injuriesLimited investigationFinal reportCessna 172N · Olive Branch, MSthe pilot misjudged the flare, resulting in the nose gear impacting the runway, and a bounced landing.Aug 27, 1999 · N4521E · Substantial damageNTSB LAX99LA286Accident · No injuriesLimited investigationFinal reportCessna 177 · Carson City, NVThe pilot's use of an excessive approach reference airspeed, his misjudged landing flare, and subsequent hard landing/porpoise. A contributing factor was the airplane's excessive approach airspeed.Aug 27, 1999 · N3327T · Substantial damageNTSB FTW99LA242Accident · Minor injuriesLimited investigationFinal reportCessna 210A · Grapevine, TXThe pilot's failure to maintain directional control of the aircraft during landing.Aug 27, 1999 · N6657X · Substantial damageNTSB CHI99LA314Accident · No injuriesLimited investigationFinal reportBeech 58 · Chesterfield, MOthe inadvertent retraction of the landing gear by the pilot.Aug 27, 1999 · N912WJ · Substantial damageNTSB CHI99IA350Incident · No injuriesIncident investigationFinal reportBritish Aerospace Jetstream 3101 · South Bend, INthe right engine accessory section's splined gear spur gear failure during cruise flight.Aug 27, 1999 · N460CE · No damageNTSB CHI99FA311Accident · 1 fatalField investigationFinal reportWalker Breezy · Janesville, WIthe inadvertent stall. A factor relating to this accident was the pilot's excessive climb rate.Aug 27, 1999 · N12BZ · DestroyedNTSB ATL99LA119Accident · Serious injuriesLimited investigationFinal reportCessna 175 · Mountain City, TNA blocked fuel system vent that resulted in fuel starvation and the complete loss of engine power.Aug 27, 1999 · N7566M · Substantial damageNTSB ANC99LA125Accident · No injuriesLimited investigationFinal reportLearjet 35 · Glennallen, AKThe pilot-in-command's delay in applying remedial action. A factor associated with the accident was the second-in-command's failure to maintain proper airspeed during final approach.Aug 27, 1999 · N90WR · Substantial damageNTSB SEA99LA149Accident · 1 fatalLimited investigationFinal reportBell 47G-2 · Benton City, WAA loss of power for undetermined reasons and the failure of the pilot to maintain adequate rotor RPM following the power loss. Contributing factors were the pilot's lack of certification and total experience.Aug 26, 1999 · N11VH · DestroyedNTSB NYC99LA212Accident · No injuriesLimited investigationFinal reportCessna 150 · Madison, OHThe pilot's delay in using carburetor heat which resulted in a partial loss of engine power, and a forced landing.Aug 26, 1999 · N2475J · Substantial damageNTSB LAX99LA284Accident · No injuriesLimited investigationFinal reportAerospatiale AS350B3 · Long Beach, CAThe failure of the pilot to maintain clearance with the fence while landing. A factor was the failure of the helipad to meet the obstacle clearance design criteria specified in FAA Advisory Circular guidance.Aug 26, 1999 · N5224R · Substantial damageNTSB IAD99WA060Accident · 1 fatalForeign investigationCessna 206G · Nairobi, KenyaAug 26, 1999 · N733YU · DestroyedNTSB FTW99LA240Accident · Serious injuriesLimited investigationFinal reportBell 206-L3 · Main Pass 225aThe pilot's failure to maintain directional control of the helicopter. A factor was the tailwind condition.Aug 26, 1999 · N6610E · Substantial damageNTSB DCA99WA078Incident · No injuriesForeign investigationBoeing 737-200 · Durban, South AfricaAug 26, 1999 · UNK · No damageNTSB CHI99LA312Accident · No injuriesLimited investigationFinal reportCessna 172M · Bloomington, ILthe pilot's inadequate visual lookout and not performing a maneuver to avoid obstructions. A factor was the road signs.Aug 26, 1999 · N61612 · Substantial damageNTSB NYC99LA211Accident · Serious injuriesLimited investigationFinal reportAeromot AMT-300 · Block Island, RIThe pilot's failure to abort the takeoffAug 25, 1999 · N111TE · DestroyedNTSB NYC99FA214Accident · 4 fatalField investigationFinal reportCessna 172N · Dyke, VAThe pilot's inadvertent flight into instrument meteorological conditions, which resulted in his inability to see the rapidly rising terrain. A factor was the pilot's inaccurate evaluation of the weather.Aug 25, 1999 · N733DH · DestroyedNTSB MIA99LA238Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Jackson, ALthe pilot's inadequate preflight planning and preparation, which resulted in taking off with the airplane's maximum gross weight exceeded, and subsequent impact with trees. Factors in this accident were high temperatures and an in-flight encounter with a…Aug 25, 1999 · N6685J · Substantial damageNTSB MIA99LA237Accident · No injuriesLimited investigationFinal reportDinkel-Brook SEA REY · Orlando, FLthe pilot's failure to maintain control of the airplane resulting in an inadvertent stall at too low an altitude to recover.Aug 25, 1999 · N1168D · Substantial damageNTSB LAX99LA283Accident · No injuriesLimited investigationFinal reportBell UH-1B · Lost Hills, CAFailure and separation of the 90-degree gearbox as a result of the disengagement of the pinion and gear teeth. The cause(s) of the pinion and gear disengagement were undetermined.Aug 25, 1999 · N999SJ · Substantial damageNTSB FTW99LA239Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-401 · Hart, TXThe pilot's failure to maintain clearance with power lines.Aug 25, 1999 · N15119 · Substantial damageNTSB CHI99LA309Accident · 1 fatalLimited investigationFinal reportPinick Horizon 2 · Grain Valley, MOThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall. Contributing to the accident was the pilot's lack of experience in this type of airplane.Aug 25, 1999 · N787TP · DestroyedNTSB ANC99LA124Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Iliamna, AKThe pilot's selection of an unsuitable takeoff area, and an inadvertent stall. Factors associated with the accident were large wave/swells, and low light conditions (dawn).Aug 25, 1999 · N930TG · Substantial damageNTSB SEA99IA148Incident · No injuriesIncident investigationFinal reportEmbraer ERJ-135 · Moses Lake, WAMinimum aircraft control exceeded during takeoff test flight, which resulted in dragging a wing on the runway surface.Aug 24, 1999 · PTZJA · Minor damageNTSB NYC99LA209Accident · Serious injuriesLimited investigationFinal reportMorrisey 2150A · Ellisburg, NYThe pilot's delay in applying carburetor heat which resulted in the loss of power, and his misjudgment of the flare during the forced landing.Aug 24, 1999 · N312BW · Substantial damageNTSB NYC99FA210Accident · 1 fatalField investigationFinal reportPiper PA-18-150 · Saddle Island, METhe pilot's failure to maintain altitude/clearance from trees.Aug 24, 1999 · N98PK · Substantial damageNTSB LAX99LA282Accident · No injuriesLimited investigationFinal reportAerospatiale AS350BA · Kahului, HIThe pilot's initial misjudgment of the wind speed and his decision to continue a downwind landing approach when his speed and altitude profile was inadequate, and his failure to maintain main rotor rpm, resulting in settling with power and a hard landing.Aug 24, 1999 · N6094S · Substantial damageNTSB LAX99LA281Accident · Minor injuriesLimited investigationFinal reportAyres S2R-G10 · Stanfield, AZThe pilot's delay in aborting the takeoff after noting sluggish acceleration during the takeoff roll, which resulted in a runway overrun.Aug 24, 1999 · N20523 · Substantial damageNTSB FTW99LA236Accident · Minor injuriesLimited investigationFinal reportAeronca 7DC · Helena, ARThe student pilot's failure to maintain clearance from a tree. A factor associated with the accident was the pilot's low altitude.Aug 24, 1999 · N4526E · Substantial damageNTSB DCA99WA080Incident · No injuriesForeign investigationBoeing 767 · Copenhagen, DenmarkAug 24, 1999 · OYKDN · Minor damageNTSB DCA99RA074Accident · 1 fatalForeign investigationMcDonnell Douglas MD-90 · Hualien, TaiwanAug 24, 1999 · B7873NTSB SEA99LA145Accident · Minor injuriesLimited investigationFinal reportCessna 182J · Yellow Pine, IDMisjudged approach resulting in landing long. Factors include an intentional ground-loop, excessive airspeed and an embankment.Aug 23, 1999 · N2808F · Substantial damageNTSB SEA99FA146Accident · 2 fatalField investigationFinal reportRepublic RC-3 · Chimacum, WAThe inadequate visual lookout by both the pilot-in-command and second pilot, and the pilot-in-command's failure to maintain sufficient flying speed to prevent a stall condition. Contributing factors were the transmission lines, gusty wind conditions, and the…Aug 23, 1999 · N6070K · DestroyedNTSB MIA99LA235Accident · No injuriesLimited investigationFinal reportCessna 172P · Hampton, GAWas the failure of the pilot-in-command to maintain directional control after touchdown following a bounced landing, resulting in the on-ground collision with a taxiway sign and the separation of the right main landing gear.Aug 23, 1999 · N55218 · Substantial damageNTSB MIA99LA234Accident · Serious injuriesLimited investigationFinal reportBellanca 17-30A · Robbins, TNThe total loss of engine power due to failure of maintenance personnel to assure that the thru bolt nut at the Nos. 2 and 3 cylinders was adequately torqued following removal and replacement of the No. 3 cylinder approximately 328 hours earlier. Also, the…Aug 23, 1999 · N42VB · Substantial damageNTSB LAX99LA285Accident · No injuriesLimited investigationFinal reportBurkhart Grob G 103 Twin II · Llano, CAThe pilot's encounter with a sudden and violent dust devil, which caused the student pilot to lose control of the aircraft during the landing flare/touchdown.Aug 23, 1999 · N8013K · Substantial damageNTSB IAD99IA059Incident · No injuriesIncident investigationFinal reportBoeing 727-200 · Washington, DCThe inadequate lubrication of the landing gear side strut assembly by company maintenance personnel. A factor in the accident was the inadequate design of the assembly that trapped water and prevented adequate lubrication.Aug 23, 1999 · N926TS · Minor damageNTSB FTW99LA245Accident · No injuriesLimited investigationFinal reportCessna 150K · Springdale, ARThe inadequate visual lookout by both pilots.Aug 23, 1999 · N6015G · 2 aircraft · Substantial damageNTSB FTW99LA234Accident · Minor injuriesLimited investigationFinal reportHughes 269B · Russellville, ARThe improper touchdown by the flight instructor.Aug 23, 1999 · N44KH · Substantial damageNTSB FTW99FA235Accident · 1 fatalField investigationFinal reportBeech D-35 · Seminole, OKThe loss of engine power caused by oil starvation, which resulted in the failure of the #6 cylinder connecting rod bolts. A factor was the pilot's performance of an evasive maneuver to avoid impacting buildings, trees, people on the ground, and power lines.Aug 23, 1999 · N2934B · DestroyedNTSB DCA99RA073Accident · Minor injuriesForeign investigationMcDonnell Douglas MD-11 · Hong Kong, ChinaAug 23, 1999 · UNK