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 NYC89LA108Accident · No injuriesLimited investigationFinal reportBeech TC-45J · Johnstown, PAFailure of the pilot to maintain runway alignment. The crosswind and snow covered runway were related factors.NTSB MIA89FA098Accident · 2 fatalField investigationFinal reportCessna 152 · Fort Lauderdale, FLInstructor pilots failure to maintain control of the aircraft resulting in a collision with terrain.NTSB LAX89LA122Accident · No injuriesLimited investigationFinal reportBellanca 17-31ATC · Fullerton, CAThe failure of the pilot to maintain directional control during the landing roll.NTSB BFO89FA020Accident · 1 fatalField investigationFinal reportCessna 152 · Townsend, DELoss of aircraft control for unknown reasons.NTSB ANC89FA049Accident · Minor injuriesField investigationFinal reportCessna A-185-F · Puntilla Lake, AKThe pilot's failure to obtain an adequate airspeed, the turn to reverse course maneuver performed at the reduced airspeed and poor preflight planning. Contributing to the accident were the mountainous terrain and the downdraft conditions.NTSB SEA89LA054Accident · No injuriesLimited investigationFinal reportCessna 185 · Bellingham, WAThe pilot's failure to compensate for the loss of lift due to ice accumulation on the wings, his failure to control the rate of descent, and poor inflight decision making. Contributing to the accident was the pilot's fatigue.NTSB NYC89FA095Accident · 1 fatalField investigationFinal reportPiper PA-28 · Douglas Twsp, PAPoor judgement of the student pilot by flying while under the influence of alcohol, and his VFR flight in instrument meteorological conditions (IMC) without the required qualification or training. Factors factors related to the accident were: failure of the…NTSB MKC89LA074Accident · No injuriesLimited investigationFinal reportCessna 172 · Cresco, IAFailure of the pilot to maintain control of the airplane during the landing on a closed runway.NTSB LAX89LA121Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Chandler, AZThe failure of the instructor pilot to properly evaluate the weather conditions resulting in an encounter with an unanticipated downdraft condition and failure of the student pilot to maintain a proper descent rate.NTSB LAX89FA120Accident · 4 fatalField investigationFinal reportCessna 170B · Casa Grande, AZThe pilot in command's performance of aerobatic maneuvers, while flying in formation, and his failure to maintain proper clearance.NTSB CHI89LA055Accident · No injuriesLimited investigationFinal reportCessna 172N · Superior, WIFailure of the pilot to maintain directional control during the landing, which resulted in an inadvertent ground swerve. Factors related to the accident were the icy and snow covered runway conditions and the snowbank.NTSB CHI89LA053Accident · No injuriesLimited investigationFinal reportAeronca 7KCAB · Pine Creek, WIThe pilot's selection of unsuitable terrain which resulted in the failure to achieve a proper climb rate which resulted in the collision with trees. Contributing to the accident was the uphill, snow covered terrain.NTSB ATL89LA096Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Blountville, TNCarburetor ice. The pilot failed to apply carburetor heat in a timely and adequate manner. This failure resulted in the accumulation of ice to a point of failure of the engine which eliminated the heat necessary to remove the ice.NTSB SEA89FA053Accident · 3 fatalField investigationFinal reportPiper PA-60-601P · Lakeview, ORFailure of the pilot to maintain control of the aircraft, which resulted in a spin and an uncontrolled descent. Factors related to the accident were: improper maintenence by the pilot, an autopilot malfunction, the adverse weather conditions, continued flight…NTSB MKC89LA072Accident · No injuriesLimited investigationFinal reportCessna 310 · Cedar Rapids, IAThe proper touchdown point was not attained by the pilot and the crankshaft failure on one engine. Contributing to the accident were the weather conditions and the approach lights which were contacted.NTSB LAX89LA124Accident · No injuriesLimited investigationFinal reportCessna 182L · Upland, CAThe pilot failed to correct the attitude of the aircraft and achieve proper alignment with the runway prior to landing touchdown.NTSB ATL89LA097Accident · No injuriesLimited investigationFinal reportCessna 180J · W. Columbia, SCImproper torquing of the attachment bolt during installation by unknown person(s), which resulted in the separation of the bolt and nut and subsequent separation of the main landing gear from the airplane.NTSB ATL89FA095Accident · 1 fatalField investigationFinal reportBeech 95-B55 · St Marys Island, GAThe pilot continued into IMC conditions where he collided with trees.NTSB SEA89LA052Accident · Minor injuriesLimited investigationFinal reportSchweizer 269C · Forrest Grove, ORThe pilot's misjudgment of his altitude and clearance while attempting to sling-load a trailer.NTSB MKC89LA071Accident · No injuriesLimited investigationFinal reportCessna 310 · Des Moines, IAThe failure of the pilot to properly flare the airplane. Contributing to the accident were the weather conditions.NTSB MIA89LA097Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-135 · Jacksonville, FLAn unstabilized instrument approach wherein the pilot descended below the mda. Contributing factors included an inadequately equipped acft and the pilot's lack of recent instrument experience.NTSB FTW89LA063Accident · No injuriesLimited investigationFinal reportCessna 172 · Bastrop, TXInadequate preflight planning and preparation by the pilot which resulted in fuel exhaustion. Contributing to the accident were the low ceilings and fog.NTSB FTW89LA062Accident · No injuriesLimited investigationFinal reportCessna 421B · San Antonio, TXThe failure of the pilot to follow the proper procedures/directives by not following the glideslope which resulted in not being able to attain the proper touchdown point.NTSB FTW89LA061Accident · Serious injuriesLimited investigationFinal reportCessna 182 · Robstown, TXThe pilot delayed flight to an alternate destination, continued flight into instrument meteorological conditions (IMC), experienced spatial disorientation, and lost control of the aircraft. Contributing factors were: the pilot's inadequate preflight…NTSB BFO89FA019Accident · 1 fatalField investigationFinal reportBeech V35TC · Roanoke, VAThe pilot failed to maintain control of the aircraft due to spatial disorientation.NTSB ANC89FA048Accident · No injuriesField investigationFinal reportCessna U-206G · Anchorage, AKThe pilot's and company's disregard of hazardous weather conditions and the pilot's failure to maintain control of the airplane. Contributing to the accident were the gusty crosswind conditions.NTSB NYC89FA093Accident · No injuriesField investigationFinal reportPiper PA-31-350 · Toms River, NJFailure of the pilot to maintain airspeed and control of the aircraft, and his exceeding the design stress limits of the aircraft. Factors related to the accident were: autoplt malfunction due to improper installation by maintenance personnel and the pilot's…NTSB MKC89LA073Accident · No injuriesLimited investigationFinal reportCessna 310Q · Norfolk, NEThe pilot's failure to maintain adequate airspeed during the landing which resulted in an inadequate flare. Contributingto the accident were the icing conditions and ice accumulation of the wings of the airplane.NTSB MKC89LA070Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Griffithville, ARThe failure of the pilot to assure suitable terrain was being used for the landing.NTSB FTW89TL#01Accident · No injuriesClass 3Final reportAeromot Aura · Austin, TXNTSB NYC89FA097Accident · 1 fatalField investigationFinal reportBeech 95-A55 · Lake Placid, NYThe pilot's departure into known adverse weather conditions and his continued VFR flight into instrument meteorological conditions. Contributing factor(s) was: the adverse weather conditions.NTSB MKC89LA069Accident · No injuriesLimited investigationFinal reportCessna 152 · Crookston, MNThe pilot's failure to maintain control of the airplane during the landing roll. Contributing to the accident was the icy/snow covered runway.NTSB MKC89LA068Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Harrisburg, ARThe failure of the hydraulic line which rendered the brake system inoperative.NTSB MIA89FA096Accident · Minor injuriesField investigationFinal reportDouglas DC-3 · Isla Verde, PRThe failure of the flight crew to feather the left propeller and trim the aircraft after the left engine stopped producing power for undetermined reasons.NTSB LAX89DVA06Accident · Serious injuriesFinal reportGrumman G-164A · Riverdale, CAInadequate visual lookout by the pilot, when he diverted his attention. The power line was a related factor.NTSB FTW89IA064Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-9-82 · Houston, TXFailure of the TRACON final approach controller to assure radar separation between the aircraft. Factors related to the accident were: inadequate supervision by the ATC supervisor, excessive workload for the controller, unclear instructions by the controller,…NTSB DEN89LA081Accident · No injuriesLimited investigationFinal reportCessna 150 · Evanston, WYThe failure of the pilot to maintain the proper descent rate on final approach which resulted in a landing short of the runway.NTSB MKC89LA067Accident · No injuriesLimited investigationFinal reportCessna 172 · Grand Rapids, MNThe pilot's failure to adequately compensate for the crosswind conditions. Contributing to the accident were the gusty crosswind conditions.NTSB BFO89LA023Accident · 1 fatalLimited investigationFinal reportMitsubishi MU-2B-20F · San Diego, CAPilot incapacitation for an unknown reason.NTSB ATL89LA094Accident · No injuriesLimited investigationFinal reportCessna 150G · Springboro, OHLoss of power (takeoff) from carburetor ice due to improper use of carburetor heat during extended ground operation using auto fuel in weather which was conducive to icing.NTSB NYC89LA091Accident · No injuriesLimited investigationFinal reportPiper PA-24-400 · Delmont, NJFailure of the #6 connecting rod.NTSB NYC89FA092Accident · Minor injuriesField investigationFinal reportCessna S550 · Poughkeepsie, NYThe pilot's improper use of the powerplant controls, which resulted in actuation (tripping) of the reverse load limiters on the thrust reversers and subsequent reduction of available power in both engines. Factors related to the accident were: the pilot's…NTSB LAX89LA116Accident · No injuriesLimited investigationFinal reportCessna 177 · Yuba City, CAInadequate supervision by the instructor (CFI) which resulted in a delayed go-around, inadequate airspeed, and a stall/mush into the ground. A poor approach by the student pilot was a contributing factor.NTSB FTW89LA060Accident · No injuriesLimited investigationFinal reportCessna 172 · Jacksboro, TXFailure of the pilot to go around, when she did not attain the proper touchdown point (landed long) and had excessive airspeed to stop on the runway. A factor related to the accident was the unfavorable wind condition (sudden wind shift).NTSB FTW89LA059Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Temple, TXImproper planning/decision, by the pilot which resulted in fuel exhaustion, due to an inadequate supply o fuel.NTSB FTW89LA058Accident · No injuriesLimited investigationFinal reportCessna 172 · Marietta, OKFailure of the pilot to select the proper runway, which resulted in a downwind landing and an overrun of the runway. The gusty tailwind, ditch, and railing (fence) were factors.NTSB FTW89DQA03Accident · No injuriesFinal reportBurkhart Grob G109B · El Paso, TXPilot in command's loss of control due to overcontrolling the aircraft. The situation was proceeded by a high sink rate that resulted in a hard landing with an inadequate recovery from a bounced landing. Contributing to the accident was the pilot's…NTSB FTW89DQA02Accident · Serious injuriesFinal reportI.C.A. Brasov IS-28B2 · El Paso, TXThe failure of the pilot to maintain adequate airspeed, while maneuvering to land in turbulent weather, which resulted in a stall/spin and subsequent collision with a tree and the ground. Turbulence was a factor.NTSB FTW89DQA01Accident · Minor injuriesFinal reportIntermountain Mfg. Callair A-9B · El Paso, TXEngine failure due to the pilot's failure to select the fullest tanks and, failure to maintain adequate flying speed.NTSB BFO89LA018Accident · Serious injuriesLimited investigationFinal reportCessna 172I · Fort Washington, MDThe passenger failed to maintain adequate clearance from the propeller as she attempted to board the aircraft. Both the pilot failure to supervise the boarding of the passenger and the night light conditions are contributing factors to the accident.