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 SEA99LA035Accident · No injuriesLimited investigationFinal reportCessna 150L · Hillsboro, ORThe pilot's failure to maintain directional control of the aircraft. A related factor was the crosswind condition.NTSB LAX99LA107Accident · 1 fatalLimited investigationFinal reportWeatherly 620B · Yuma, AZThe pilot's failure to maintain an adequate clearance from the power lines during an aerial application flight. A factor in the accident was the dark night lighting conditions.NTSB LAX99FA106Accident · Minor injuriesField investigationFinal reportCessna 172N · El Monte, CAAn in-flight fuel fire in the left forward doorpost due to an electrical arc from an adjacent map light switch puncturing a main fuel feed line. The manufacturer's inadequate design in routing the fuel line in close proximity to electrical arc sources in the…NTSB FTW99LA084Accident · Minor injuriesLimited investigationFinal reportBeech BE-76 · Mesquite, TXThe flight instructor's inadequate supervision of the multi-engine rated instrument student during a simulated single engine landing, resulting in loss of control of the airplane. Factors were the dark night light condition, the flight instructor's inadequate…NTSB CHI99IA096Incident · No injuriesIncident investigationFinal reportCessna T210R · Tinley Park, ILthe improper installation of the pressure oil line 'B' nut by maintenance personnel. Contributing to the incident were the loose pressure oil line 'B' nut and separation of the propeller from the aircraft.NTSB LAX99TA105Accident · No injuriesFinal reportChristen Industries A-1 · Battle Mountain, NVFailure of the pilot to maintain clearance from terrain. A factor was the dust devil encountered by the airplane.NTSB LAX99LA103Accident · No injuriesLimited investigationFinal reportZivko Aeronautics Edge 540 · Livermore, CAThe manufacturer's inadequate quality control procedures, which allowed an improperly manufactured crankshaft to be shipped, resulting in the separation of one counterweight from the crankshaft lug and the subsequent catastrophic internal failure of the…NTSB LAX99FA104Accident · 2 fatalField investigationFinal reportBeech 95-B55 · Coalinga, CAthe pilot's inadvertant visual flight into instrument meteorological conditions.NTSB MIA99LA088Accident · No injuriesLimited investigationFinal reportBeech K35 · Gulfport, MSA loss of engine power due to fuel starvation caused by an obstruction in the fuel vent system while maneuvering in IMC conditions, and the subsequent ditching into the Gulf of Mexico.NTSB LAX99LA094Accident · No injuriesLimited investigationFinal reportBeech F33 · Prescott, AZA total loss of engine power for undetermined reasons.NTSB CHI99LA098Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Grand Rapids, MNthe pilot's inadequate visual lookout. A factor to the accident was the unmarked transmission wire.NTSB CHI99LA093Accident · No injuriesLimited investigationFinal reportMitsubishi 300 · Columbus, NEthe pilot-in-command failed to attain the proper touchdown point during the landing. Factors associated with the accident were the rough, snow covered terrain encountered off the end of the runway, and the low ceiling at the time of the landing.NTSB MIA99WA087Accident · No injuriesForeign investigationDouglas DC-3C · Nassau, BahamasNTSB FTW99LA083Accident · No injuriesLimited investigationFinal reportRobinson R22-B2 · Freer, TXThe passenger's inadvertent interference with the cyclic control which consequently restricted the control's movement.NTSB NYC99IA062Incident · No injuriesIncident investigationFinal reportAirbus Industrie A-320-231 · Columbus, OHa failure of the external o-rings in the nose landing gear steering module.NTSB LAX99FA101Accident · No injuriesField investigationFinal reportGrumman G-1159 · Van Nuys, CAThe pilot performed inadequate in flight planning and decided to continue the approach and landing with excessive airspeed. The pilot failed to follow company directives, which required a go around under the encountered flight conditions. This led to a long…NTSB DEN99LA041Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Colorado Sprngs, COThe pilot's failure to maintain directional control of the aircraft during landing touchdown. A factor was the sign.NTSB DEN99LA040Accident · Serious injuriesLimited investigationFinal reportHughes 369D · Baggs, WYA hard landing resulting from rotor rpm decay. Factors were the improper replacement of the turbine by company maintenance personnel resulting in the PC line nut becoming loose, and the pilot operating outside the normal height/velocity curve.NTSB DEN99LA039Accident · No injuriesLimited investigationFinal reportCessna 172N · West Jordan, UTThe pilot's failure to maintain directional control of the aircraft. Factors were his lack of recent flight experience, and his lack of experience in the make and model of aircraft.NTSB ATL99FA048Accident · 1 fatalField investigationFinal reportPiper PA-32RT-300 · Cartersville, GAIn flight collision with terrain for undetermined reasons.NTSB SEA99LA033Accident · Minor injuriesLimited investigationFinal reportRobinson R-22 · Seattle, WAThe dual student's improper touchdown while drifting during a practice autorotation. Contributing to the accident was the flight instructor (CFI) inadequate remedial action.NTSB LAX99LA133Accident · No injuriesLimited investigationFinal reportMaule M-4-220C · Prescott, AZThe pilot's inadequate compensation for the crosswind condition, which led to a loss of directional control and an inadvertent ground loop.NTSB LAX99LA097Accident · No injuriesLimited investigationFinal reportCessna 414 · Phoenix, AZThe overload failure of the left main gear locking mechanism due to improper system rigging by maintenance personnel.NTSB CHI99LA092Accident · No injuriesLimited investigationFinal reportCessna 172RG · Lawrenceville, ILthe fatigue fracture of the landing gear actuator.NTSB MIA99LA084Accident · No injuriesLimited investigationFinal reportCessna 172K · Marathon, FLThe pilot's improper use of elevator control while landing in gusty winds resulting in the aircraft nosing down and the propeller and wing contacting the runway.NTSB LAX99LA099Accident · No injuriesLimited investigationFinal reportCessna 172N · Fort Ord, CAFuel exhaustion due to the pilot's becoming lost and disoriented during multiple attempts at completing an ILS approach.NTSB IAD99LA073Accident · No injuriesLimited investigationFinal reportMonocoupe 110 · Limington, MEPilot's failure to maintain directional control during the landing rollout.NTSB FTW99LA082Accident · No injuriesLimited investigationFinal reportCessna 150M · Baton Rouge, LAThe pilot's failure to maintain an adequate approach airspeed which resulted in a excessive descent rate and hard landing and the pilot's failure to recover from a bounced landing. A factor was the pilot's lack of total experience.NTSB SEA99LA034Accident · No injuriesLimited investigationFinal reportCessna 182A · Conner, MTThe pilots delayed remedial action during an aborted landing. Factors include a slush-covered runway.NTSB MIA99LA083Accident · No injuriesLimited investigationFinal reportBeech A24R · Philadelphia, MSThe failure of the pilot to ensure the aircraft tie down ropes were free from the aircraft prior to taxiing. This resulted in the aircraft turning uncontrolled when taxi was initiated due to a partially tied left wing, the pilot loosing control of the…NTSB LAX99LA098Accident · Minor injuriesLimited investigationFinal reportMaule M-7-235 · Boulder City, NVThe failure of the pilot-in-command to properly position the floatplane landing gear for a water landing and failure to verify the landing gear position resulting in an inadvertent wheels down landing on water.NTSB FTW99LA081Accident · No injuriesLimited investigationFinal reportCessna 188 · Alexandria, LAThe pilot's failure to maintain directional control of the airplane during the landing roll resulting in an inadvertent ground loop.NTSB FTW99LA080Accident · No injuriesLimited investigationFinal reportEurocopter BK 117 B-1 · Hockley, TXThe pilot's failure to maintain clearance with the power lines. A factor was the sunglare reducing the pilot's visibility.NTSB NYC99LA059Accident · Serious injuriesLimited investigationFinal reportAerospatiale 355 · Toledo, OHThe pilot's decision to continue the flight which resulted in inadvertent flight into IMC, and the subsequent spatial disorientation and loss of control. A factor in the accident was the inaccuracy of the weather forecast.NTSB NYC99LA058Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Duanesburg, NYThe instructor pilot's improper use of carburetor heat which resulted in carburetor ice, and a loss of engine power. A factor in the accident was the instructor pilot's failure to initiate the simulated engine failure from a point where a successful forced…NTSB MIA99WA082Accident · No injuriesForeign investigationCessna 172M · Rum Cay, BahamasNTSB MIA99LA081Accident · Minor injuriesLimited investigationFinal reportCessna 210G · Lake Placid, FLa total loss of engine power due to an in-flight separation of the crankshaft, caused by a fatigue crack that originated from the aft fillet radius of the No. 2 main journal, resulting in a forced landing in a field and impact with a tree.NTSB LAX99LA095Accident · No injuriesLimited investigationFinal reportBeech 95 · Henderson, NVa loss of power in one engine due to the student pilot inadvertently selecting the off position on one fuel selector valve while accomplishing the prelanding checklist. The instructor's inadequate supervision of the flight was also causal.NTSB LAX99FA096Accident · 1 fatalField investigationFinal reportBeech C99 · Bishop, CAthe pilot's failure to follow procedures and directives and his failure to maintain clearance from mountainous terrain.NTSB DEN99IA038Incident · No injuriesIncident investigationFinal reportBritish Aerospace BAE 146-200A · Aspen, COThe inadequate maintenance overhaul of the number four turbine disc by the manufacturer. A factor was the turbine blade's failure due to high cycle fatigue fracture.NTSB ANC99FA028Accident · Serious injuriesField investigationFinal reportBeech 1900C · Saint Mary'S, AKThe pilot's descent below the minimum descent altitude on the instrument approach. Factors were pilot fatigue resulting from the pilot's rest period being interrupted by scheduling discussions and the night weather conditions of low ceilings and whiteout.NTSB NYC99FA060Accident · 1 fatalField investigationFinal reportCessna 170A · Leominster, MAThe pilot's failure to maintain the proper altitude during the approach.NTSB MIA99LA079Accident · Minor injuriesLimited investigationFinal reportWolf Seawind 3000 · Bradenton, FLTotal loss of engine power due to a burned piston for undetermined reasons resulting in a forced landing to unsuitable terrain and the subsequent crash landing onto a golf course.NTSB MIA99LA077Accident · Minor injuriesLimited investigationFinal reportLee S. Harvard LONG-EZ · Spring Hill, FLThe failure of the pilot to insure the canopy was closed prior to takeoff resulting in an aborted takeoff, overheating of the brakes, and a roll over when the aircraft was turned off the runway into the grass in an attempt to stop.NTSB LAX99LA093Accident · Serious injuriesLimited investigationFinal reportAerostar RX-9 · Peoria, AZThe pilot's attempted flight in an area of forecasted high winds and his inadequate compensation for those wind conditions once encountered.NTSB NYC99LA057Accident · No injuriesLimited investigationFinal reportCessna 310R · Monticello, NYThe pilot in command's loss of directional control.NTSB MIA99LA080Accident · No injuriesLimited investigationFinal reportCessna 172P · Cleveland, MSThe pilot's improper recovery from a bounced landing, resulting in a blown nose tire, loss of directional control, and subsequent collision with terrain.NTSB MIA99LA078Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Sanford, FLthe pilot misjudged the flare resulting in a hard landing and damage to the airplane.NTSB IAD99LA030Accident · Minor injuriesLimited investigationFinal reportWSK PZL Krosno KR-03A · Kutztown, PAwas the in-flight encounter with thermal sink over unsuitable terrain for landing.NTSB NYC99LA055Accident · Minor injuriesLimited investigationFinal reportHughes 369D · Herminie, PAThe partial loss of engine power for undetermined reasons.