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 LAX93LA126Accident · Minor injuriesLimited investigationFinal reportCessna Soloy TU206G · Cochise, AZThe pilot's continued flight into known forecasted icing conditions, in an airplane not certificated for such flight, which resulted in an engine flameout due to engine ice/water injestion, and the pilot's inability to restart the engine due to inadequate…Feb 19, 1993 · N9987M · Substantial damageNTSB BFO93LA029Accident · No injuriesLimited investigationFinal reportAgusta A109AII · Lincoln Park, NJThe pilot's inadequate visual lookout, which resulted in his misjudgment of clearance.Feb 19, 1993 · N67K · Substantial damageNTSB BFO93LA028Accident · No injuriesLimited investigationFinal reportPiper PA-31T1 · Pittsfield, METhe pilot's inadequate inflight decision to continue a landing without runway lights, and his delay in initiating a go-around. A related factor was the pilot's over confidence in his ability.Feb 19, 1993 · N6192A · Substantial damageNTSB ATL93FA061Accident · 4 fatalField investigationFinal reportRobinson R22B · Atlanta, GAThe failure of the pilot/applicant of the R22B, N621SG, to follow low approach procedures, and the failure of the designated examiner/observer in the R22B to maintain visual separation from the Cessna 152, N5532Q. Contributing factors to the accident were:…Feb 19, 1993 · N621SG · 2 aircraft · DestroyedNTSB ANC93FA033Accident · 2 fatalField investigationFinal reportBell 214B1 · Ketchikan, AKInadequate maintenance of the hydraulic servo actuator which led to the fatigue failure and loss of flight control. In addition, the flightcrew did not, or was unable to, jettison the external load. Factors which contributed to the accident were: the pilot…Feb 19, 1993 · N114CR · DestroyedNTSB SEA93T#A02Accident · No injuriesClass 3Final reportCessna 152 · Amalga, UTFeb 18, 1993 · N714WZ · Substantial damageNTSB MIA93WA070Accident · No injuriesForeign investigationDouglas DC-7C · Santo Domingo, Dominican RepublicFeb 18, 1993 · HI599 · Substantial damageNTSB LAX93LA124Accident · 1 fatalLimited investigationFinal reportBertone Challenger II · Boulder City, NVThe pilot's loss of airplane control due to physical impairment as a result of either drugs or other cardiovascular reasons, or both.Feb 18, 1993 · N4391V · DestroyedNTSB FTW93LA088Accident · No injuriesLimited investigationFinal reportCessna 340A · Clovis, NMThe pilot's failure to execute a go around. Factors were the tailwind, the icy runway conditions and the pilot's improper touchdown pointFeb 18, 1993 · N2666J · Substantial damageNTSB CHI93LA091Accident · Minor injuriesLimited investigationFinal reportBeech 77 · Evansville, INThe partial failure of the normal brake system.Feb 18, 1993 · N3733B · Substantial damageNTSB BFO93FA030Accident · 1 fatalField investigationFinal reportAmerican General AG5B · Vergennes, VTVFR flight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain sufficient altitude or clearance from snow covered terrain after becoming spatially disoriented in whiteout conditions. The adverse weather and snow covered…Feb 18, 1993 · N1192Z · DestroyedNTSB MIA93WA078Accident · No injuriesForeign investigationDassault-Breguet Falcon 10 · Aurillac, FranceFeb 17, 1993 · N85JM · Substantial damageNTSB SEA93LA066Accident · Serious injuriesLimited investigationFinal reportCessna 120 · Battleground, WAThe pilot in command's allowing the aircraft to enter a stall/spin condition. Factors contributing to the accident were a tailwind, power lines and trees.Feb 16, 1993 · N2100V · DestroyedNTSB LAX93LA123Accident · No injuriesLimited investigationFinal reportCessna 152 · Galt, CAThe pilot's inadequate compensation for the existing crosswind conditions and his failure to maintain directional control of the aircraft. A factor in the accident was the pilot's limited total flight experience.Feb 16, 1993 · N67615 · Substantial damageNTSB LAX93LA121Accident · No injuriesLimited investigationFinal reportBeech C35 · Susanville, CAThe pilot's poorly planned approach. Contributing to this accident was the pilot's misjudging his distance and altitude and the prevailing light snow conditions.Feb 16, 1993 · N1844D · Substantial damageNTSB LAX93FA125Accident · 2 fatalField investigationFinal reportCessna T210M · Coalinga, CAThe pilots inadequate preflight planning and his failure to select a cruise altitude which would ensure adequate terrain clearance during the night cross country. Factors in the accident were: the mountainous nature of the terrain and the dark night light…Feb 16, 1993 · N761NE · DestroyedNTSB LAX93FA118Accident · 1 fatalField investigationFinal reportBeech E33 · Avalon, CAThe pilot's alcoholic impairment of efficiency and judgement which resulted in his attempt to perform aerobatics at night in hilly terrain at an altitude inadequate for terrain clearance.Feb 16, 1993 · N7882R · DestroyedNTSB MIA93LA067Accident · No injuriesLimited investigationFinal reportCessna 152 · Fort Mccoy, FLThe in-flight collision with a large bird.Feb 15, 1993 · N95527 · Substantial damageNTSB LAX93LA122Accident · No injuriesLimited investigationFinal reportCessna 182E · Corning, CAThe pilot's poor preflight inspection. Factors relating to this accident were the not properly secured oil cap and the oil covered windshield.Feb 15, 1993 · N9300X · Substantial damageNTSB LAX93FA119Accident · 4 fatalField investigationFinal reportPiper PA-32-300 · Truckee, CAThe pilot's continued VFR flight into instrument meteorological conditions. The adverse weather conditions contributed to the accident.Feb 15, 1993 · N15267 · DestroyedNTSB BFO93LA027Accident · No injuriesLimited investigationFinal reportCessna 210K · Sunbury, OHThe pilot's failure to maintain directional control during the takeoff roll. The soft terrain was a related factor.Feb 15, 1993 · N8110G · Substantial damageNTSB MIA93LA069Accident · No injuriesLimited investigationFinal reportAerotek Pitts S-1T · Sun City, FLThe pilot-in-command's failure to verify fuel load after refueling, which resulted in loss of engine power due to fuel exhaustion.Feb 14, 1993 · N49308 · Substantial damageNTSB FTW93LA086Accident · No injuriesLimited investigationFinal reportH. Raymond Busby Mustang II · Arlington, TXThe pilot's failure to attain the proper touchdown point and his delay in initiating the aborted landing. A factor was the wet runway and deteriorated braking actionFeb 14, 1993 · N80RH · DestroyedNTSB DEN93IA027Incident · No injuriesIncident investigationFinal reportBoeing 757-222 · Grand Junction, COFailure of the left generator control unit (gcu), integrated drive generator (idg), right (side) engine indicator and crew alert system (eicas), and bus tie bar (btb).Feb 14, 1993 · N508UA · No damageNTSB ATL93FA058Accident · 2 fatalField investigationFinal reportCessna 402B · Geneva, ALThe pilot's failure to maintain minimum controllable airspeed during the initial climb, which resulted in a loss of aircraft control and collision with trees and terrain.Feb 14, 1993 · N69402 · DestroyedNTSB LAX93LA120Accident · No injuriesLimited investigationFinal reportBell 47G · Bakersfield, CAThe clutch slippage and failure of the pilot to jettison the load.Feb 13, 1993 · N1185W · Substantial damageNTSB FTW93LA087Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Magdalena, NMFuel exhaustion power loss due to the pilot's failure to refuel. Factors were the unsuitable terrain and the dark nightFeb 13, 1993 · N2187R · Substantial damageNTSB CHI93LA090Accident · No injuriesLimited investigationFinal reportCessna 172 · Weeping Water, NEThe pilot's failure to abort the takeoff when the airplane first touched down on the clear area adjacent to the departure runway.Feb 13, 1993 · N6640A · Substantial damageNTSB BFO93IA026Incident · No injuriesIncident investigationFinal reportBoeing 737-130 · Portland, METhe pilot in command's excessive airspeed during approach, and his failure to follow the proper braking procedures during landing as per company training. Factors contributing to the accident include a tailwind and a wet, downhill runway.Feb 13, 1993 · N403PE · No damageNTSB NYC93IA064Incident · No injuriesIncident investigationFinal reportBoeing 727-200 · Newark, NJThe pilot's disorientation while taxiing, resulting in a runway incursion. Factors contributing to the incident were: the failure of the flight crew to communicate with the ATC ground controller to verify their position; the inadequate crew coordination; and…Feb 12, 1993 · N79771 · No damageNTSB LAX93LA117Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Hughson, CAThe failure of the intake valve. The soft terrain contributed to this accident.Feb 12, 1993 · N62733 · Substantial damageNTSB LAX93LA116Accident · No injuriesLimited investigationFinal reportCessna 210 · Fullerton, CAThe pilot's failure to follow the checklist. A factor relating to this accident was the misadjustment of the landing gear locking mechanism which caused intermittent operation.Feb 12, 1993 · N9668T · Substantial damageNTSB LAX93LA115Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Chowchilla, CAThat the pilot failed to maintain directional control. The pilot's failure to use the tailwheel lock and the soft and wet terrain were factors relating to this accident.Feb 12, 1993 · N10212 · Substantial damageNTSB FTW93LA085Accident · Minor injuriesLimited investigationFinal reportBellanca 14-19-3A · Graham, TXThe loss of engine power due to fuel starvation due to the improper position of the fuel tank selector. Factors were the pilot's failure to follow the checklist and the lack of suitable terrain for the forced landing.Feb 12, 1993 · N8876R · Substantial damageNTSB LAX93LA134Accident · Minor injuriesLimited investigationFinal reportBeech D35 · San Manuel, AZThe pilot's improper use of carburetor heat. Contributing to this accident were weather conditions which were conducive to the formation of carburetor ice.Feb 11, 1993 · N2908B · Substantial damageNTSB LAX93LA114Accident · No injuriesLimited investigationFinal reportEagle DW-1 · Rachael, NVThe pilot poor preflight planning and preparation. The road sign was a factor relating to this accident.Feb 11, 1993 · N8805D · Substantial damageNTSB FTW93LA084Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Ruston, LAFailure at a hydraulic fitting, which resulted in a hydraulic leak, loss of hydraulic fluid, and subsequent loss of braking action during the landing roll.Feb 11, 1993 · N6290Y · Substantial damageNTSB LAX93FA112Accident · 4 fatalField investigationFinal reportCessna 414 · Truckee, CAThe decision of the pilot not to follow instrument flight rule procedures during instrument meteorological conditions and poor preflight planning which resulted in operation of the airplane over the maximum gross weight and reduced performance. Factors in the…Feb 10, 1993 · N711LT · DestroyedNTSB FTW93LA083Accident · No injuriesLimited investigationFinal reportSwearingen SA-26AT · Ardmore, OKPilot's failure to refuel and fuel exhaustion. Factors were a fuel leak in the wing and unsuitable terrainFeb 10, 1993 · N34UA · DestroyedNTSB FTW93LA082Accident · Minor injuriesLimited investigationFinal reportCessna 210D · Hillsboro, TXThe power loss due to fuel exhaustion for undetermined reasons. Factors were the dark night conditions and the lack of suitable terrain for the ensuing forced landing.Feb 10, 1993 · N3876Y · Substantial damageNTSB BFO93LA025Accident · No injuriesLimited investigationFinal reportCessna 172RG · White Plains, NYThe collapse of the left main landing gear for an undetermined reason.Feb 10, 1993 · N6433V · Substantial damageNTSB ATL93FA060Accident · Serious injuriesField investigationFinal reportCessna 337D · Nashville, TNThe pilot's failure to ensure an adequate fuel supply for the flight, which resulted in fuel exhaustion.Feb 10, 1993 · N861CP · DestroyedNTSB MIA93LA066Accident · No injuriesLimited investigationFinal reportCessna 172K · Plymouth, FLUndetected damage to the right main gear brake line which developed a leak and resulted in failure of the brake. The pilot was unable to maintain directional control, or stop the aircraft, prior to colliding with aircraft parked to the side of the runway.Feb 9, 1993 · N79563 · Substantial damageNTSB LAX93LA111Accident · No injuriesLimited investigationFinal reportCobb Intl Exec 90 · Chandler, AZThe manufacturer's inadequate quality control which resulted in the fatigue of the valve stem. The soft terrain contributed to this accident.Feb 9, 1993 · N89678 · Substantial damageNTSB MIA93FA065Accident · 2 fatalField investigationFinal reportForney Ercoupe F-1 · Aguadilla, PRExcessive elevator control input by an unknown occupant at an airspeed above maneuvering speed which caused both forward wing spars to fail. Contributing to the accident was fuel exhaustion due to poor in flight planning/decision by the pilot-in-command and…Feb 8, 1993 · N7555C · DestroyedNTSB FTW93LA081Accident · Minor injuriesLimited investigationFinal reportBell 206L-1 · Vermillion 39The pilot's failure to maintain proper altitude.Feb 8, 1993 · N2244W · Substantial damageNTSB SEA93LA064Accident · Minor injuriesLimited investigationFinal reportRobinson R22 Beta · Bend, ORRotor RPM was not maintained. Factors to the accident were: low ceiling and poor inflight planning.Feb 7, 1993 · N4085M · Substantial damageNTSB NYC93LA062Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · New Cumberland, PAThe loss of engine power for undetermined reasons, resulting in a forced landing in the river.Feb 7, 1993 · N32307 · Substantial damageNTSB MIA93LA064Accident · 1 fatalLimited investigationFinal reportPiper PA-23-250 · Atlantic Ocean (Atlantic Ocean)The pilot-in-command's overconfidence in his own abilities and the subsequent failure of both engines due to fuel exhaustion. Contributing factors were the failure of the pilot to perform in-flight fuel consumption calculations, and the unsuitable terrain for…Feb 7, 1993 · N5044Y · DestroyedNTSB LAX93LA191Accident · No injuriesLimited investigationFinal reportBeech F35 · Sandy Valley, NVThe pilot's failure to perform a preflight inspection of the airplane, and to assure that an adequate supply of fuel was on board the aircraft. This subsequently led to an inadequate fuel supply in the left tank, and fuel starvation. A factor related to the…Feb 7, 1993 · N4255B · Substantial damage