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 MIA92LA047Accident · No injuriesLimited investigationFinal reportCessna 150M · Hollywood, FLTotal loss of engine power during the initial climb due to fuel starvation as a result of the pilot's failure to perform an adequate preflight to determine the quantity of fuel on board.NTSB MIA92LA044Accident · Serious injuriesLimited investigationFinal reportCessna 150H · Valdosta, GAThe pilot-in-command's improper in-flight decision to continue flight into deteriorating weather conditions. Contributing to the accident was the pilot's overconfidence in his personal ability to fly in instrument conditions.NTSB MIA92IA046Incident · No injuriesIncident investigationFinal reportBoeing 727-223 · St. ThomasPilot-in-command's delayed remedial action to correct for a gust of wind during the landing flare.NTSB MIA92FA045Accident · 1 fatalField investigationFinal reportCessna 152 · Naples, FLThe pilot-in-command's incapacitation due to an undetermined cardiovascular event which resulted in an uncontrolled descent into the ground.NTSB CHI92LA058Accident · No injuriesLimited investigationFinal reportCessna 150 · Charlestown, INFuel exhaustion. Factors related to the accident were inadequate maintenance of the airplane and the pilot's decision to fly an airplane with known mechanical deficiencies.NTSB CHI92LA057Accident · No injuriesLimited investigationFinal reportCessna 182 · Point Lookout, MOFailure of the pilot to attain the proper touchdown Point and maintain directional control of the aircraft. A factor related to the accident was: a go-around was not performed by the pilot.NTSB ANC92FA083Accident · 1 fatalField investigationFinal reportPiper PA-31T3, T1040 · Ninilchik, AKUndetermined.NTSB NYC92LA046Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Lockport, NYAn inadvertent stall during an attempted go-around by the second pilot. Factors related to the accident were improper use of the flight controls by both pilots and the second pilot's attempted control of the airplane.NTSB NYC92LA041Accident · No injuriesLimited investigationFinal reportCessna 150 · Gansevoort, NYThe pilot's improperly planned approach, resulting in a landing on an icy runway at excessive speed; and unable to stop on the available runway and subsequent collision with trees. Factors related to the accident were the pilot's failure to obtain a weather…NTSB MIA92LA042Accident · No injuriesLimited investigationFinal reportBell 206L-3 · Charlotte, NCThe pilot in commands failure to maintain tailrotor ground clearance while hovering resulting in the tail striking the ground and the subsequent separation of the tailrotor and gearbox.NTSB FTW92LA042Accident · Minor injuriesLimited investigationFinal reportGrumman AA1B · Spur, TXThe pilot's selection of unsuitable terrain for takeoff.NTSB CHI92RA060Incident · No injuriesForeign investigationBoeing B-747-121 · Nakina, CanadaNTSB NYC92LA045Accident · No injuriesLimited investigationFinal reportCessna 152 · Orford, NHThe student pilot became lost and disoriented.NTSB LAX92LA063Accident · Serious injuriesLimited investigationFinal reportPiper PA34-200T · San Andreas, CAThe failure of the nonmultiengine/instrument rated pilot in command to accomplish the proper emergency procedure during a loss of engine power. Contributing to the accident was the pilot's improper training, lack of instrument experience, heavy fog reported…NTSB LAX92LA062Accident · No injuriesLimited investigationFinal reportCessna 210M · Palo Alto, CAAn engine power loss due to a partial blockage of the fuel selector valve with debris.NTSB DCA92MA011Accident · 9 fatalMajor investigationFinal reportBeech 400 · Rome, GAThe captain's decision to initiate visual flight into an area of known mountainous terrain and low ceilings and the failure of the flightcrew to maintain awareness of their proximity to the terrain.NTSB CHI92LA052Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Carlyle, ILFuel contamination and blockage of the carburetor, which restuled in fuel starvation. The high obstructions (trees) were a related factor.NTSB CHI92LA051Accident · No injuriesLimited investigationFinal reportLuscombe 8-F · Chapin, IAFailed connecting rod which resulted in a catastrophic engine failure. A factor related to the accident was unsuitable terrain.NTSB CHI92FA053Accident · 1 fatalField investigationFinal reportPiper PA-24-250 · Berrien Springs, MIThe pilot-in-command's (cfi's) poor in-flight planning/decision-making and misjudged fuel supply/consumption. A related factor is overconfidence in personal ability.NTSB CHI92DEV01Accident · Serious injuriesFinal reportQuickie Quickie 1 · Carmi, ILAn engine bearing seizure and a premature forced landing flare.NTSB NYC92FA044Accident · 3 fatalField investigationFinal reportMBB BO-105CBS · De Ruyter, NYAn inflight collision with terrain after the pilot experienced spatial disorientation. Factors related to the accident were the night conditions, and the lack of visual cues.NTSB LAX92FA058Accident · 5 fatalField investigationFinal reportPiper PA31-350 · Temple Bar, AZThe pilot-in-command's poor inflight decision by not electing to proceed to an alternate airport and to continue to the flight under visual flight rules into instrument meteorological conditions. The low ceilings and visibilities across the flight route and…NTSB FTW92LA040Accident · No injuriesLimited investigationFinal reportBell 206L-3+ · Arlington, TXThe helicopter's autorotational landing performance capability was exceeded. Factors were the proper descent rate was not possible for the PIC and sufficient information from the manufacturer was not provided.NTSB DEN92LA015Accident · No injuriesLimited investigationFinal reportBeech V35 · Erie, COAn inadvertent gear up landing when the pilot in command and designated examiner failed to use proper procedures. A factor was: failure of the landing gear extension/retraction motor.NTSB CHI92LA050Accident · No injuriesLimited investigationFinal reportCessna 140 · Minneapolis, MNRemedial action was not performed by the CFI. A factor related to the accident was directional control was not maintained by the student pilot.NTSB CHI92LA048Accident · 1 fatalLimited investigationFinal reportBeech A36 · Rensselaer, INThe pilot's improper aircraft handling which resulted in an inadvertent stall and descent. Factors related to the accident were the obscuration & icing conditions.NTSB MIA92LA041Accident · Minor injuriesLimited investigationFinal reportLogan GN-1 · Quincy, FLThe pilot's improper recovery from a bounced landing that caused the loss of control in flight. A contributing factor was the pilot's lack of total experience.NTSB FTW92LA041Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Houston, TXThe pilot's failure to correctly calculate fuel consumption and the loss of engine power. A factor was the unsuitable terrain.NTSB FTW92FA035Accident · Serious injuriesField investigationFinal reportCessna U206G · Pasadena, TXFuel starvation due to the pilots' improper boost pump procedure. Factors were pilots' failure to follow checklist, dark night, and unsuitable terrain.NTSB CHI92LA056Accident · No injuriesLimited investigationFinal reportCessna 177 · Elkhart, INThe pilot in command's failure to use carburetor heat. A factor to the accident was the carburetor icing conditions.NTSB NYC92LA043Accident · No injuriesLimited investigationFinal reportCessna 177B · Dalmatia, PAThe pilot's failure to maintain proper altitude and object clearance which resulted in a collision with power lines.NTSB MIA92LA043Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Vero Beach, FLFailure of the pilot to maintain directional control during the landing roll. This resulted in the collision with a sign. Contributing to the accident was his lack of total experience.NTSB MIA92LA040Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300T · Daytona Beach, FLTotal loss of engine power for undetermined reasons.NTSB LAX92LA057Accident · 1 fatalLimited investigationFinal reportPiper PA-34-200T · Pine Valley, CAThe pilot's failure to monitor the proper altitude over obserable rising terrain. A contributing factor was the pilot's encounter with a strong downdraft.NTSB FTW92LA039Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Las Cruces, NMThe pilot's misjudgment of the airplane's performance which led to a situation where it could not climb above the rising terrain. A factor was the high density altitude which existed in the mountains at the time of the accident.NTSB CHI92LA082Accident · No injuriesLimited investigationFinal reportCessna 140 · Fairbury, NEThe pilot's improper use of the brakes. An associated factor is the pilot's lack of total experience in the type airplane.NTSB CHI92LA043Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Rochester, MNImproper use of autopilot during approach which resulted in proper alignment not maintained by the pilot. Factors related to the accident were turbulence and crosswinds, over confidence in aircraft's capability and overconfidence in personal ability.NTSB CHI92FA044Accident · 1 fatalField investigationFinal reportPiper PA-32RT/300T · Camdenton, MOThe pilot's disregard for wind conditions, not aborting the takeoff, and inadequate remedial action by the pilot after the airplane became airborne. Factors associated with the accident are an inadequate weather evaluation by the pilot, not maintaining…NTSB BFO92LA012Accident · No injuriesLimited investigationFinal reportJohn W Upton SA-300 · Leon, WVThe defective welding between the axle and the wheel assembly causing the right main gear to collapse.NTSB ANC92LA026Accident · No injuriesLimited investigationFinal reportPiper PA-38 · Talkeetna, AKThe pilot's improper flare following an aborted takeoff, which resulted in a hard landing and the subsequent loss of control of the airplane. Contributing to the accident was the pilot's lack of total experience in the type of operation.NTSB SEA92LA027Accident · Serious injuriesLimited investigationFinal reportBeech 35 · Klamath Falls, ORPilot factor in that he failed to follow IFR procedures. Factors to the accident were generator failure, operation with known deficiencies with equipment, and poor inflight planning.NTSB SEA92FA026Accident · 7 fatalField investigationFinal reportCessna 172P · Snohomish, WAA visual lookout was not maintained.NTSB NYC92LA040Accident · No injuriesLimited investigationFinal reportPiper PA28R-200 · Piqua, OHThe pilot allowed the airplane to get too low on short final and struck the terrain short of the runway. Factors in the accident were the proper glide path was not maintained, resulting in the intended touchdown point not being attained.NTSB NYC92IA042Incident · No injuriesIncident investigationFinal reportAirbus Industrie A-310-324 · Covington, KYThe installation of an improper restrictor in the bleed air line by the manufacturer, which caused the rvdt to fail due to heat, and brought about the uncommanded power loss.NTSB LAX92LA061Accident · No injuriesLimited investigationFinal reportNorth American-Kenney T-28D-5, NA-260 · Bermuda Dunes, CAAn inadequate annual inspection performed by the mechanic. Contributing to this accident was the deterioration of the fuel bladder self-sealing lining and partial blockage of the fuel screens.NTSB LAX92LA060Accident · No injuriesLimited investigationFinal reportCessna 180 · Bakersfield, CAThe pilot's failure to maintain directional control of the aircraft during the landing roll due to inadequate compensation for the existing wind conditions. A factor in the accident was the pilot's lack of total experience.NTSB FTW92LA043Accident · No injuriesLimited investigationFinal reportPiper PA-22 · New Roads, LAThe student pilot's loss of directional control and the resultant ground loop. Factors were the cfi's lack of supervision and the ditch adjacent to the runway.NTSB FTW92LA037Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Southlake, TXThe pilots failure to maintain directional control of the airplane. A factor was improper airspeed prior to touchdown which resulted in a hard landing.NTSB CHI92LA045Accident · No injuriesLimited investigationFinal reportPiper PA-15 · Indianapolis, INRemedial action was not performed by the cfi/pic. A factor related to the accident was directional control was not maintained by the student pilot.NTSB ATL92FA029Accident · 3 fatalField investigationFinal reportAerospatiale AS350D Astar · Fuquay-Varina, NCThe pilot's improper decision in continuing the flight with a known engine problem, and the subsequent seizure of the number two engine bearing, resulting in engine stoppage. Darkness was a related factor.