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 NYC89FA073Accident · 4 fatalField investigationFinal reportGrumman GA-7 · Spartansburg, PAThe pilots decision to disregard the weather forecast and attempt flight into known icing conditions. After the wings started to ice up, the pilot initiated a climb but could not maintain airspeed and inadvertantly stalled the aircraft which entered an…NTSB MIA89LA072Accident · No injuriesLimited investigationFinal reportCessna 152 · Orlando, FLFailure of the pilot to flare for landing and improper recovery from a bounced landing.NTSB LAX89FA095Accident · 1 fatalField investigationFinal reportMooney M20F · Truckee, CAThe pilot's decision to fly with a known deficiency of the aircraft, the worn fuel injector with an interior leak, which resulted in loss of engine power, and the pilot's failure to maintain adequate airspeed, which resulted in a stall.NTSB CHI89DEP01Accident · 1 fatalFinal reportCessna T337G · Green Bay, WIThe pilot's loss of aircraft control, due to the loss of cockpit/instrument panel lighting for an undetermined reason, the inoperative penlight, and subsequent spatial disorientation of the pilot. Factors related to the accident were: darkness and the adverse…NTSB DEN89LA068Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Las Cruces, NMThe loss of right engine power for undetermined reason(s), and the failure of the instructor pilot to feather the right engine. Factors related to the accident were: failure of the left main gear locking mechanism to engage and the unprepared (rough/uneven)…NTSB ATL89DMG02Accident · Minor injuriesFinal reportCessna 172P · Mooresville, NCFailure of the pilot to maintain airspeed on final approach to land, which resulted in an inadvertent stall. Factors related to the accident were: carburetor icing conditions, night conditions, and the pilot's decision to land at an unlighted runway.NTSB SEA89IA042Incident · No injuriesIncident investigationFinal reportFairchild SA-227-AC · Seattle, WAInoperative nosewheel steering due to improper maintenance. Contributing to the incident was the lack of adequate maintenance information available in the aircraft manuals.NTSB LAX89LA094Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Show Low, AZDelayed retraction of flaps and the inadvertent application of left rudder due to diversion of attention resulting in the airplane's departure from the runway. A contributing factor was the inexperience of the student pilot.NTSB ANC89LA038Accident · No injuriesLimited investigationFinal reportCessna 207 · Kalskag, AKThe pilot failed to properly align the airplane on the runway for landing, then failed to maintain directional control after landing. Contributing to the accident was the pilots operation of the airplane with an inoperative landing light and the dark night…NTSB SEA89LA037Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Port Townsend, WAImproper approach and flare technique on the part of the pilot, resulting in a hard landing. Contributing to the accident were tall trees surrounding the airstrip.NTSB LAX89FA093Accident · 1 fatalField investigationFinal reportGrumman AA5A · Lake View, CAThe pilot's inadvertent flight into a box canyon.NTSB LAX89FA092Accident · 2 fatalField investigationFinal reportRobinson R22A · Santa Barbara, CAFailure of the pilot to maintain adequate altitude, proper airspeed for the reduced visibility, and an adequate visual outlook to avoid a collision with power transmission cable. Contributing to the accident was reduced visibility due to fog.NTSB LAX89DUJ04Accident · 2 fatalFinal reportLehman/Jerrell Vans RV-4 · Tucson, AZPoor judgement by the pilot in attempting and then improperly performing an aerobatic maneuver after takeoff, resulting in a stall/spin to the ground.NTSB LAX89DUG02Accident · 1 fatalFinal reportMason AJM-1 · Cajalco, CAThe pilot's intentional descent into the terrain. Contributing factors to the accident were the pilot's phychological problems and his lack of experience in this aircraft.NTSB FTW89DRA02Accident · Serious injuriesFinal reportPitts S1A · Santa Fe, TXPilot in command failed to maintain adequate altitude and clearance on final approach.NTSB DEN89IA067Incident · No injuriesIncident investigationFinal reportBoeing 707-323B · Salt Lake City, UTThe pilot-in-command's attempt to align the airplane with the runway at an altitude insufficient for safe maneuvering, resulting in the no. 1 engine striking the runway. Contributing factors include obscured visibility due to fog, the captain's loss of depth…NTSB ATL89LA082Accident · No injuriesLimited investigationFinal reportCessna 150 · Cambridge, OHThe pilot's failure to maintain directional control in crosswind conditions while on short final and the improperly adjusted carburetor idle flow.NTSB MKC89FA055Accident · 1 fatalField investigationFinal reportChampion 7EC · Luxemburg, MNThe pilot failed to maintain adequate airspeed which resulted in a stall and loss of aircraft control. The pilot's failure to observe weight and balance limitations of the aircraft was a contributing factor.NTSB LAX89LA096Accident · No injuriesLimited investigationFinal reportCessna 150H · Napa, CAThe cfi's delay in aborting the takeoff, leading to a loss of directional control.NTSB FTW89LA043Accident · No injuriesLimited investigationFinal reportHiller OH-23B · Wichita Falls, TXThe pilot's improper use of the carburetor heat during flight and his improper flare during an autorotative landing. Contributing factors were: carburetor icing conditions, improper in-flight planning/decision by the pilot, a tailwind during the landing, and…NTSB DEN89LA066Accident · No injuriesLimited investigationFinal reportCessna 172RG · Larimore, NDInadequate supervision by the flight instructor. Factors related to the accident were: failure of the student pilot to attain a proper touchdown point, his delay in configuring the aircraft & executing the go-around, icy/snowy runway conditions, and the…NTSB CHI89GA048Accident · 2 fatalFinal reportPiper PA-28-180 · Chicago, ILInadequate preflight of the aircraft by the pilot, which resulted in fuel exhaustion due to an inadequate supply of fuel. Factors related to the accident were: high obstructions and retaining wall in the emergency landing area.NTSB CHI89DEC02Accident · Serious injuriesFinal reportPiper PA-28R-201 · Brighton, MIInstallation of an improper oil drain valve by other maintenance personnel and their failure to follow the applicable airworthiness directive (AD 81-11-02/R1), resulting in subsequent interference between the landing gear and oil drain valve. This caused the…NTSB ATL89FA081Accident · 2 fatalField investigationFinal reportCessna 172 · Hartsville, TNThe pilot allowing the aircraft to lift-off prematurly at a slow airspeed and his failure to maintain directional control before inadvertently entering a stall. Contributing to the accident was the pilot's experience level and lack of qualifications.NTSB ANC89LA036Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Girdwood, AKThe pilot's failure to maintain control of the airplane while attempting to takeoff from a sloped terrain that was too steep for a safe operation. Contributing to the accident was the downhill, icy terrain conditions and the pilot's overconfidence in both his…NTSB NYC89LA071Accident · No injuriesLimited investigationFinal reportMooney M20J · Lumberton, NJFailure of the pilot to maintain directional control during a touch-and-go, which resulted in an inadvertent ground swerve. The presence of trees near the runway was considered to be a factor.NTSB DEN89FA064Accident · Minor injuriesField investigationFinal reportConvair 580 · Buena Vista, COInadvertent deactivation of fuel to the left engine as the pilot was making a precautionary shutdown of the right engine, and his failure to follow the emergency checklist procedure. Related factors were: low gearbox oil pressure (at flight altitude), and…NTSB CHI89MA047Accident · No injuriesMajor investigationFinal reportDassault-Breguet Falcon 900 · South Bend, INFailure of the thrust reverser actuator links due to a manufacturing/design problem. Factors related to the accident were: the adverse runway conditions and the crosswind.NTSB CHI89MA046Accident · No injuriesMajor investigationFinal reportBoeing 737-201 · Chicago, ILPrevious damage to the aft cone (engine mounting) bolt, which resulted in mismatched surfaces between the bolt and isolation mount, loss of torque during cyclic loading of the mounting bolt, and subsequent fatigue failure of the bolt.NTSB ATL89IA080Incident · No injuriesIncident investigationFinal reportBoeing 757-225 · Atlanta, GAFailure of operator maintenance personnel to accomplish an applicable service bulletin.NTSB SEA89LA038Accident · No injuriesLimited investigationFinal reportCessna 180A · Arlington, WAThe pilot attempted to hand-prop the engine without properly securing it.NTSB MIA89LA070Accident · No injuriesLimited investigationFinal reportCessna 152 · Jacksonville, FLThe Cessna 152 pilot misjudged clearance between his aircraft and the parked Piper PA-28.NTSB FTW89LA041Accident · Serious injuriesLimited investigationFinal reportDouglas DC-3 · Laredo, TXThe pic's disregard for the security of the cargo that permitted its shift during the takoeff roll. This resulted in an aft CG situation and a subsequent stall and loss of aircraft control. A contributing factor in the accident was the mismanagement of the…NTSB DEN89LA065Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Medicine Lake, MTSelection of unsuitable terrain by the pilot, resulting in a collision with snowdrifts during landing ground run.NTSB BFO89LA016Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Elkview, WVInadequate preflight by the pilot and inadequate crew/group coordination by the flight leader (CFI), which resulted in fuel exhaustion due to an inadequate supply of fuel. A factor related to the accident was: the presence of trees in the emergency landing…NTSB ATL89LA079Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Williamsburg, OHA defective gasket in the fuel strainer which caused a restriction in fuel flow during climbout.NTSB NYC89LA068Accident · Serious injuriesLimited investigationFinal reportRobinson R-22HP · Ronkonkoma, NYThe pilot's improper operation of the rotorcraft flight controls and a resulting low rotor RPM condition.NTSB LAX89LA090Accident · Minor injuriesLimited investigationFinal reportBoeing A75 · Huntington Bch, CAThe pilot's inadequate evaluation of the weather, and the sudden wind shift that was encountered during takeoff. The trees & wall were related factors.NTSB LAX89LA089Accident · No injuriesLimited investigationFinal reportCessna 190 · Sonoma, CAA jammed brake mechanism resulting in the pilot's inability to maintain directional control.NTSB LAX89LA088Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301T · Santa Ana, CAPoor preflight planning and preparation by selecting the wrong runway despite NOTAM and ATIS information indicating the runway was closed.NTSB LAX89FA086Accident · Minor injuriesField investigationFinal reportFairchild SA227AC · Los Angeles, CAThe failure of the fuel tanker driver to see and avoid the moving aircraft. Factors contributing to the accident were the driver's obstructed visibility through the right side of the vehicle's cab, and the dusk light conditions.NTSB FTW89FA042Accident · 1 fatalField investigationFinal reportCessna 150L · Zachary, LAThe pilot's loss of aircraft control due to spatial disorientation after encountering instrument meteorological weather conditions (IMC) shortly after takeoff, his intentional takeoff into adverse weather conditions, and the operator's inadequate supervision…NTSB DEN89LA063Accident · No injuriesLimited investigationFinal reportCessna 140 · Farmington, NMImproper use of brakes which resulted in an inadvertent ground swerve.NTSB DEN89LA062Accident · Minor injuriesLimited investigationFinal reportBeech V35B · Broomfield, COFuel starvation due to improper fuel tank selectior operation by the pilot. A factor related to the accident was: unprepared (rough/uneven) terrain short of the runway.NTSB ATL89FA078Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Bagley, ALInadequate maintenance by other maintenance personnel which allowed a foreign object to remain in the engine and damage/short the spark plugs in the #2 and #3 cylinders. Trees in the emergency landing area contributed to the accident. If shoulder harnesses…NTSB ATL89DEK01Accident · No injuriesFinal reportCessna 182Q · Columbus, OHThe pilot's improper flared and improper recovery from a bounced landing. A factor related to the accident was: the gusty wind condition.NTSB NYC89LA069Accident · Minor injuriesLimited investigationFinal reportBeech S-35 · Bridgeport, CTThe improper fuel selector position and loss of power to the engine due to fuel exhaustion.NTSB MKC89LA054Accident · No injuriesLimited investigationFinal reportBeech C-23 · Greenfield, IAThe pilot's failure to assure an an adequate supply of fuel was on board in order to complete the flight.NTSB MIA89LA066Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300 · Fort Myers, FLFailure of the #5 connecting rod bolt. Factors related to the accident were: dark night and the soft and wet (marshy) terrain conditions in the emergency landing area.NTSB LAX89LA087Accident · No injuriesLimited investigationFinal reportCessna T207A · Page, AZImproper in-flight planning/decision by the pilot and his inadequate visual lookout (failure to see-and-avoid the obstruction). Factors related to the accident were: the birds, the pilot's excessive maneuver, and the transmission line.