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 FTW01LA106Accident · No injuriesLimited investigationFinal reportCessna 172G · N. Little Rock, ARthe pilot's delayed go-around on landing.NTSB FTW01FA104Accident · 1 fatalField investigationFinal reportCessna 402B · Del Rio, TXthe loss of control due to a jammed trim tab, which resulted from the failure of maintenance personnel to properly secure the trim tab actuator rod when installing a replacement elevator.NTSB DEN01LA091Accident · No injuriesLimited investigationFinal reportBellanca BL17-30 · Columbus, NMThe impact with terrain following an inadvertent stall/mush by the pilot during a go-around. A contributing factor was a dust devil.NTSB DEN01FA090Accident · Serious injuriesField investigationFinal reportPiper PA-39 · Fort Collins, COthe loss of right engine power on take-off as a result of the separation of the right engine's alternate air door, which lodged in the fuel servo air inlet. A factor was the lack of suitable terrain for a forced landing.NTSB ANC01LA070Accident · No injuriesLimited investigationFinal reportCessna 207A · Deadhorse, AKThe pilot's failure to maintain altitude/clearance while maneuvering. Factors associated with the accident were flat light conditions, and snow-covered terrain.NTSB SEA01WA078Accident · No injuriesForeign investigationCessna TR182 · Bella Bella, BC, CanadaNTSB NYC01IA107Incident · No injuriesIncident investigationFinal reportEmbraer EMB-145 · Norfolk, VAThe manufacturer's inadequate quality control, which resulted in a jammed elevator trim actuator.NTSB MIA01LA128Accident · No injuriesLimited investigationFinal reportSteen Aero Lab Skybolt I · Germantown, TNThe pilot's failure to conduct proper preflight planning and preparation, resulting in fuel exhaustion during cruise flight, and the subsequent emergency descent and forced landing to a residential street colliding with a vehicle, utility pole, mail box, and…NTSB DEN01LA089Accident · No injuriesLimited investigationFinal reportCessna 140A · Greeley, COtotal failure of the right main landing gear spring due to fatigue.NTSB ANC01LA059Accident · No injuriesLimited investigationFinal reportCessna 207 · Kongiganak, AKThe pilot's selection of an unsuitable area for taxi. A factor associated with the accident was a rough/uneven taxiway.NTSB SEA01LA077Accident · No injuriesLimited investigationFinal reportCessna 172S · Renton, WAA Canadian goose which crossed the aircraft's flight path and impacted the left wing during the aircraft's final approach.NTSB CHI01FA128Accident · 2 fatalField investigationFinal reportCessna 210L · Farmington, MOThe fracture of the crankshaft due to fatigue, the propeller separating from the airplane while in-flight, which resulted in the propeller striking the empennage structure and flight controls, yielding the airplane uncontrollable. Contributing factors to the…NTSB LAX01LA157Accident · No injuriesLimited investigationFinal reportBell 206-L3 · Willcox, AZA loss of engine power due to the likely unporting of the fuel tank pickups as the helicopter was maneuvered to look at animals on the ground. Also causal was the pilot's misjudged touchdown point during an autorotational approach, which resulted in the…NTSB LAX01LA156Accident · No injuriesLimited investigationFinal reportRobinson R22 beta · Fortuna, CAThe student's improper procedure during a practice emergency that exceeded the instructor's reaction capability.NTSB FTW01LA102Accident · No injuriesLimited investigationFinal reportCap 232 · Laporte, TXFailure of the brake system during taxi. A contributing factor was the pilot's decision to continue taxiing after discovering the brakes were not functioning normally.NTSB FTW01FA101Accident · 2 fatalField investigationFinal reportPiper PA-34-220T · Brackettville, TXthe pilot's intentional low flight and his poor judgment to intentionally fly into known adverse weather, which resulted in an in-flight collision with terrain. Contributing factors were the dark night conditions and the thunderstorm.NTSB DCA01WA038Incident · No injuriesForeign investigationBoeing 767-300ER · Zurich, SwitzerlandNTSB NYC01WA104Accident · 3 fatalForeign investigationMooney M20E · Saint Mamet, FranceNTSB NYC01LA110Accident · No injuriesLimited investigationFinal reportCessna 172K · Honesdale, PAThe pilot's loss of directional control during the landing roll. A factor was gusting winds.NTSB NYC01LA103Accident · No injuriesLimited investigationFinal reportCessna 177 · Hampton, NHThe pilot's inadvertent encounter with a downdraft, which resulted in a collision with trees. A factor related to the accident were the downdraft wind conditions.NTSB MIA01LA134Accident · No injuriesLimited investigationFinal reportDavid G. Holmes Bensen Gyrocopter · Troy, ALThe failure of the pilot to maintain airspeed during the approach resulting in a hard landing. A contributing factor in the accident was the loss of engine power during final approach due to undetermined reasons.NTSB LAX01LA159Accident · No injuriesLimited investigationFinal reportRyan ST3KR · Murrieta, CAThe failure of the pilot to maintain an adequate visual lookout during taxi to avoid striking a post. A factor in the accident was the inadequate marking of the obstruction by airport personnel.NTSB LAX01LA155Accident · No injuriesLimited investigationFinal reportCessna 180K · Glendale, AZThe pilot's loss of directional control during the landing roll resulting in a ground loop/swerve and collision with a runway marker sign.NTSB LAX01LA154Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Oxnard, CAThe fracture and separation of the number 3 cylinder exhaust valve head resulting in a loss of engine power and a forced landing. A factor in the accident was the soft field where the forced landing occurred.NTSB LAX01LA153Accident · 1 fatalLimited investigationFinal reportHolt Christian Eagle II · White Water, CAThe pilot's failure to maintain an adequate clearance from the power lines during an intentional low level flight.NTSB LAX01FA152Accident · 1 fatalField investigationFinal reportCessna 310F · Carmel Valley, CAThe in-flight loss of control of the airplane in instrument meteorological conditions for undetermined reasons.NTSB IAD01LA046Accident · Minor injuriesLimited investigationFinal reportPiper PA-32R-300 · King George, VAThe failure of cylinder case and thru studs due to fatigue, which resulted in a loss of engine power over unsuitable terrain.NTSB FTW01LA103Accident · Serious injuriesLimited investigationFinal reportJoe Underwood Lazer Z · Bossier City, LAthe pilot's failure to maintain control during the low level maneuver. A contribiting factor was the windshear.NTSB CHI01LA120Accident · No injuriesLimited investigationFinal reportAmerican General AG5B · Culver, INthe wrong runway selected by the pilot which resulted in a tailwind landing condition. Factors to the accident were the tailwind, the wet runway, the reduced braking action, and the airport perimeter fence.NTSB ANC01LA051Accident · No injuriesLimited investigationFinal reportCessna 150 · Cantwell, AKThe pilot's selection of unsuitable terrain for landing and subsequent nose over during the landing flare. Factors in the accident were soft, snow-covered terrain on the runway.NTSB ANC01LA050Accident · Minor injuriesLimited investigationFinal reportStinson 108-3 · Glennallen, AKA total failure of the engine and subsequent rupture of the crankcase during cruise flight. A factor in the accident was unsuitable terrain for a forced landing.NTSB SEA01LA076Accident · Minor injuriesLimited investigationFinal reportCessna 172 N · Sultan, WAThe pilot's failure to maintain adequate clearance from trees and terrain during the airplane's initial climb.NTSB SEA01LA075Accident · Minor injuriesLimited investigationFinal reportCessna 177RG · Seattle, WAthe reverse rigging of the aileron flight control system resulting in aileron deflections opposite that of the pilot's inputs which lead to an uncontrolled descent into the terrain. Factors include the pilot's failure to detect the misrigged ailerons during…NTSB NYC01LA099Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Winchester, VAThe pilot's inadequate fuel management, which resulted in fuel starvation.NTSB CHI01LA122Accident · Serious injuriesLimited investigationFinal reportBellanca 7ECA · Kimball, NEThe pilot not maintaining clearance from the terrain. A factor was that the pilot misjudged the low altitude flight maneuver.NTSB ANC01TA049Accident · No injuriesFinal reportPiper PA-18 · King Salmon, AKThe pilot's inadequate compensation for wind conditions, and inadequate weather evaluation resulting in a loss of directional control during the landing roll. Factors in the accident were the presence of a quartering tailwind, and an inadvertent ground loop.NTSB NYC01LA105Accident · No injuriesLimited investigationFinal reportCessna 337F · Quinton, VAThe pilot's improper recovery from a bounced landing. Factors in the accident were the crosswind, and the pilot's lack of experience in make and model.NTSB NYC01IA126Incident · No injuriesIncident investigationFinal reportPiper PA-31-350 · Newark, OHThe company maintenance personnel's failure to comply with the service bulletin, which resulted in a fuel boost pump leakage and subsequent fire during taxi. A factor was the manufacturer's confusing service bulletin.NTSB MIA01LA127Accident · No injuriesLimited investigationFinal reportChristen Industries Eagle II · Alexander City, ALA total loss of engine power during cruise flight due to an internal disconnection in the fuel injector control assembly as a result of a failure of the maintenance facility to follow proper installation procedures, resulting in a forced landing and collision…NTSB CHI01LA121Accident · No injuriesLimited investigationFinal reportCessna 182L · Stromsburg, NEthe inadequate in-flight planning/decision and the flight to a destination alternate not performed by the pilot. Contributing factors were the crosswind and gusts.NTSB ANC01TA048Accident · No injuriesFinal reportde Havilland DHC-2 · Anchorage, AKA failure of the pilot to maintain adequate distance/clearance from a cement barricade while taxiing into a parking spot after landing. A factor was the presence of a barricade adjacent to the parking spot.NTSB NYC01FA102Accident · 1 fatalField investigationFinal reportCessna 152 · La Grange, KYThe student pilot's failure to maintain adequate airspeed while maneuvering the airplane at low altitude. A factor was the pilot's overconfidence in his abilities.NTSB MIA01LA125Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Chapel Hill, NCThe loss of engine power for undetermined reasons during takeoff, resulting in an inflight collision with trees during the subsequent emergency landing. A factor in the accident was the lack of suitable terrain to conduct an emergency landing.NTSB MIA01FA126Accident · 4 fatalField investigationFinal reportPiper PA-32-300 · Fort Lauderdale, FLThe pilot's exceeding the forward center of gravity (CG) ) limits at the time of engine start, the inability of the pilot to control the airplane due to the exceeded CG limits, the failure of the pilot to abort the takeoff with sufficient runway remaining,…NTSB LAX01LA150Accident · No injuriesLimited investigationFinal reportCessna 172P · Torrance, CAThe failure of the pilot-in-command to execute a proper landing flare, which resulted in an improper touchdown attitude and a subsequent loss of directional control. A factor in the accident was the difference between landing characteristics of the Katana and…NTSB LAX01LA136Accident · Serious injuriesLimited investigationFinal reportAirbus Industrie A320-232 · Las Vegas, NVThe failure of the pilot-in-command to properly evaluate a hazardous weather advisory and his failure to adequately alter course and flight altitude to avoid the area of hazardous weather.NTSB NYC01LA106Accident · No injuriesLimited investigationFinal reportGlobe GC-1B · Swanton, OHthe failure of the pilot to verify the landing gear was extended prior to landing, due to diverted attention.NTSB MIA01WA132Accident · 1 fatalForeign investigationBeech 55 · Carache, VenezuelaNTSB LAX01LA151Accident · No injuriesLimited investigationFinal reportCessna 152 · Chandler, AZThe pilot's premature flare, which resulted in an inadvertent stall and a bounced landing. A factor was the improper recovery from a bounced landing.NTSB LAX01LA149Accident · Serious injuriesLimited investigationFinal reportCessna 172B · Lancaster, CAThe pilot's delay reversing course while flying toward rising terrain in a box canyon. Factors in the accident included a downdraft on the lee side of a ridge forming the box canyon, high density altitude, and the pilot's improper use of flaps.