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 NYC95LA070Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201 · Wilmington, OHThe pilot's failure to maintain adequate terrain clearance during a go around, which resulted in an inflight collision with a snowbank. A factor is the pilot's delay in initiating a go around.Mar 11, 1995 · N8395Y · Substantial damageNTSB FTW95LA136Accident · No injuriesLimited investigationFinal reportCessna 152 · New Roads, LAThe pilot's improper bounced landing recovery technique. Factors were his failure to execute a go-around, his improper landing flare, and the other pilot's premature taxiing onto the runway for takeoff.Mar 11, 1995 · N89359 · Substantial damageNTSB FTW95LA135Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-235 · Hobart, OKThe pilot's inadequate compensation for the wind conditions. A factor was the gusty wind condition.Mar 11, 1995 · N8514W · Substantial damageNTSB CHI95LA100Accident · Serious injuriesLimited investigationFinal reportCessna 182A · Bowling Green, MOThe pilot misjudged the fuel supply.Mar 11, 1995 · N5015D · Substantial damageNTSB BFO95LA031Accident · No injuriesLimited investigationFinal reportRobinson R-22B · Frederick, MDthe helicopter pilot's inadequate control of the aircraft during the attempted takeoff.Mar 11, 1995 · N2346P · Substantial damageNTSB ATL95LA060Accident · No injuriesLimited investigationFinal reportCessna 182P · Alabaster, ALThe pilot's failure to perform an adequate preflight inspection of the aircraft, which resulted in a takeoff with the control wheel lock installed.Mar 11, 1995 · N6236F · Substantial damageNTSB FTW95LA141Accident · No injuriesLimited investigationFinal reportBurken Ultimate · New Braunfels, TXThe loss of engine power due to fuel starvation due to a fuel leak resulting from a loose fuel line fitting. A factor was the lack of suitable terrain for the forced landing.Mar 10, 1995 · N122MB · Substantial damageNTSB ATL95LA063Accident · Serious injuriesLimited investigationFinal reportCessna 172L · Smyrna, TNThe flight instructor's failure to ensure that the magnetos were not energized prior to positioning the propeller, and the dual student's failure to place the ignition switch in the off position after the first start attempt.Mar 10, 1995 · N4383Q · No damageNTSB ANC95LA037Accident · No injuriesLimited investigationFinal reportPiper J3 · Skwentna, AKA frozen engine breather tube which resulted in a loss of oil and engine power.Mar 10, 1995 · N88415 · Substantial damageNTSB ANC95LA034Accident · Serious injuriesLimited investigationFinal reportCessna 207A · Ketchikan, AKThe pilot's continued visual flight rules (VFR) flight into instrument meteorological conditions (IMC). Factors in the accident were fog and low ceilings, and a failure of the operator to follow their procedures specified in the company operations manual.Mar 10, 1995 · N6478H · DestroyedNTSB FTW95LA172Accident · No injuriesLimited investigationFinal reportBrantly Helicopter B-2B · Elk City, OKThe pilot's failure to maintain proper altitude during a hovering turn. A factor was the low temperature.Mar 9, 1995 · N2266U · Substantial damageNTSB FTW95LA133Accident · No injuriesLimited investigationFinal reportCessna 337C · Porter, TXThe pilot's failure to extend the landing gear. Factors were his failure to use a checklist and his diverted attention.Mar 9, 1995 · N2621S · Substantial damageNTSB CHI95LA099Accident · No injuriesLimited investigationFinal reportCessna 152 · Waukesha, WIthe student pilot's failure to maintain directional control during an aborted takeoff. A factor was the snow covered ground which contributed to the airplane nosing over as it departed the runway.Mar 9, 1995 · N4598B · Substantial damageNTSB ANC95LA033Accident · No injuriesLimited investigationFinal reportChampion 8GCBC · Fairbanks, AKThe pilot's inadequate pre-flight planning. A short takeoff area that was covered with soft snow were factors in the accident.Mar 9, 1995 · N88297 · Substantial damageNTSB SEA95LA068Accident · No injuriesLimited investigationFinal reportBell 230 · Portland, ORThe pilot-in-command's failure to maintain clearance from the perimeter fence while landing. A factor was the heliport perimeter fence.Mar 7, 1995 · N230LF · Substantial damageNTSB SEA95LA063Accident · No injuriesLimited investigationFinal reportHiller UH-12C · Bonners Ferry, IDRotor RPM was not maintained. Factors to the accident were: inadequate in flight planning/decision and suitable terrain was not available.Mar 7, 1995 · N222TE · Substantial damageNTSB SEA95FA064Accident · 1 fatalField investigationFinal reportMcDonnell Douglas 369E · Lakecreek, ORThe pilot's failure to maintain adequate clearance from the surrounding terrain. A factor was the transmission lines.Mar 7, 1995 · N59HS · DestroyedNTSB CHI95LA096Accident · No injuriesLimited investigationFinal reportCessna T210N · Rockford, ILA disconnect of the alternator belt, and failure of the pilot to attain a down and locked condition of the gear with the emergency extension system.Mar 7, 1995 · N6622N · Substantial damageNTSB BFO95LA029Accident · Minor injuriesLimited investigationFinal reportPiper PA-34-200T · London, OHthe loss of engine power (both engines, cause undetermined) shortly after lift off. Related factors are the foggy, dark night conditions, and the unsuitable terrain encountered during the subsequent forced landing.Mar 7, 1995 · N2299M · DestroyedNTSB MIA95LA085Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Crystal Springs, MSThe failure of the pilot in command to insure the aircraft contained adequate fuel to complete the flight.Mar 6, 1995 · N6619Q · Substantial damageNTSB MIA95LA084Accident · No injuriesLimited investigationFinal reportBell 206L · Miami, FLThe failure of the pilot-in-command to maintain adequate engine power while maneuvering, his failure to take remedial action to recover from the resulting descent, and his decision to make a precautionary landing on the water.Mar 6, 1995 · N164BH · Substantial damageNTSB CHI95LA094Accident · No injuriesLimited investigationFinal reportBeech 1900 · Minneapolis, MNthe pilot-in-command's failure to maintain clearance from obstacles during taxi operations. Related factors are the dark night light conditions and the wrong taxi route.Mar 6, 1995 · N130UE · Substantial damageNTSB SEA95LA061Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Forks, WAThe loss of power for undetermined reasons and the lack of suitable terrain for a successful forced landing.Mar 5, 1995 · N4778A · Substantial damageNTSB MIA95LA081Accident · No injuriesLimited investigationFinal reportCessna R182 · Orlando, FLthe failure of the pilot-in-command to insure the landing gear was extended before landing.Mar 5, 1995 · N47U · Substantial damageNTSB LAX95LA127Accident · No injuriesLimited investigationFinal reportBoeing B75N1 · Gaviota, CAinadequate maintenance and service of the aircraft's carburetor heat system, and the pilot's intentional flight into adverse weather conditions. The lack of a suitable area for the emergency landing was a factor.Mar 5, 1995 · N450SR · Substantial damageNTSB LAX95IA128Incident · No injuriesIncident investigationFinal reportATR 42 · Las Vegas, NVan unexpected lateral control movement associated with in-flight turbulence.Mar 5, 1995 · N266AT · No damageNTSB FTW95FA130Accident · 4 fatalField investigationFinal reportCessna 421C · El Prado, NMThe pilot's decision to continue flight into known adverse weather conditions and the ensuing inadvertent stall due to airframe ice. Factors were the weather conditions.Mar 5, 1995 · N421BL · DestroyedNTSB SEA95LA060Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Albany, ORThe pilot's failure to use carburetor heat. Factors include icing conditions and the dark night light conditions.Mar 4, 1995 · N6663S · DestroyedNTSB SEA95LA059Accident · Minor injuriesLimited investigationFinal reportIsrael Aircraft Industries 1124A · Gillette, WYThe pilot in command's failure to retract the spoilers and the consequent high sink rate on an unstabilized final approach. Factors contributing to the accident were: icing conditions, both pilots diverted attention, inadequate flight crew coordination, and…Mar 4, 1995 · N311BR · Substantial damageNTSB NYC95IA065Incident · No injuriesIncident investigationFinal reportFokker F28-4000 · Huntington, WVThe fatigue fracture of the left main landing gear upper torque link.Mar 4, 1995 · N479AU · Minor damageNTSB LAX95LA126Accident · No injuriesLimited investigationFinal reportSchweizer G-164A · Robbins, CAA failure of the engine master rod. A factor in the accident was the soft, wet condition of the field available for the forced landing.Mar 4, 1995 · N5450 · Substantial damageNTSB LAX95LA125Accident · Minor injuriesLimited investigationFinal reportMooney M20J · Pacoima, CAthe failure of the engine overhaul shop to install the correct gasket stack on the propeller governor pad as required by the engine manufacturer.Mar 4, 1995 · N11385 · Substantial damageNTSB FTW95LA132Accident · Minor injuriesLimited investigationFinal reportSchmanski Kitfox III · Greeley, COThe pilot's inadequate compensation for wind conditions. A factor was a sudden wind shift.Mar 4, 1995 · N951BW · DestroyedNTSB BFO95LA030Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Belfast, MEthe student pilot's failure to adequately compensate for wind conditions. A related factor was the presence of high snowbanks along the sides of the runway.Mar 4, 1995 · N5554Z · Substantial damageNTSB ATL95FA057Accident · 2 fatalField investigationFinal reportCessna 208B · Gainesville, GAThe pilots failure to maintain the minimum descent altitude during the approach. The weather and dark night light condition were factors.Mar 4, 1995 · N227DM · DestroyedNTSB ANC95LA032Accident · No injuriesLimited investigationFinal reportCessna 185F · Port Alsworth, AKThe pilot's inadvertent activation of the right brake pedal during the landing roll.Mar 4, 1995 · N6166N · Substantial damageNTSB SEA95LA058Accident · No injuriesLimited investigationFinal reportMooney M20C · Omak, WAThe elevator push rod separation due to fatigue. Factors contributing to the accident were the pilot in command's failure to insure compliance with the airworthiness directive and the frozen push rod bearing.Mar 3, 1995 · N7836V · Substantial damageNTSB NYC95LA067Accident · No injuriesLimited investigationFinal reportCessna 180J · West Dover, VTA loss of power for undetermined reasons. The frozen snow covered terrain was a factor.Mar 3, 1995 · N180BF · Substantial damageNTSB NYC95LA066Accident · No injuriesLimited investigationFinal reportCessna 175 · Quantico, VAthe failure of a connecting rod, which resulted in the total loss of engine power. Subsequently, the airplane was ditched.Mar 3, 1995 · N7175M · Substantial damageNTSB LAX95LA124Accident · No injuriesLimited investigationFinal reportCessna 172 · Prescott, AZfailure of the pilot to maintain directional control.Mar 3, 1995 · N7369F · Substantial damageNTSB LAX95FA129Accident · 4 fatalField investigationFinal reportPiper PA-23-150 · Oceanside, CAThe pilot's intentional VFR flight into known adverse weather. The low ceiling was a factor.Mar 3, 1995 · N1260P · DestroyedNTSB ATL95LA058Accident · No injuriesLimited investigationFinal reportCessna 150L · Jefferson, GAThe loss of engine power because of sticking valves. A factor was the continuous use of an improper fuel grade.Mar 3, 1995 · N1321Q · Substantial damageNTSB ATL95LA056Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Charleston, SCThe failure of the position washer in the fuel selector valve, which resulted in the fuel starvation of the engine.Mar 3, 1995 · N7498R · Substantial damageNTSB FTW95FA129Accident · Minor injuriesField investigationFinal reportCessna 208B · Ardmore, OKThe pilot's continued flight into adverse weather conditions. Factors were the icing conditions prevailing at the destination airport, and the pilot's inability to maintain visual lookout due to windshield icing.Mar 2, 1995 · N9448B · Substantial damageNTSB MIA95WA082Accident · No injuriesForeign investigationBeech V35A · Nassau, BahamasMar 1, 1995 · N8066R · Substantial damageNTSB FTW95LA128Accident · Serious injuriesLimited investigationFinal reportBeech 58P · Montrose, COThe pilot's failure to refuel the airplane resulting in a forced landing. The adverse weather conditions were factors.Mar 1, 1995 · N208DK · DestroyedNTSB CHI95LA097Accident · No injuriesLimited investigationFinal reportPiper PA-32RT · Joliet, ILthe failure of the number four cylinder due to a loose cylinder hold down stud. A factor in the accident was the embankment.Mar 1, 1995 · N1978J · Substantial damageNTSB MIA95FAMS2Accident · 2 fatalMissing aircraftFinal reportCessna 152 · MissingUndetermined. The airplane and occupants have not been located.Feb 28, 1995 · N25900 · DestroyedNTSB FTW95IA126Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas MD11 · Dallas-Ft Worth, TXThe local controller's task overload, which led him to forget to issue appropriate traffic advisories and to lose his awareness of the traffic situation, and the failure of the controller's supervisor to recognize that the controller had reached or exceeded…Feb 28, 1995 · N1763 · 2 aircraft · No damageNTSB FTW95FA125Accident · 1 fatalField investigationFinal reportBeech 95-B55B · Midway, ARThe pilot's impairment of judgment and performance due to drugs, his lack of qualification/training, and his resultant inability to maintain control of the airplane.Feb 28, 1995 · N207Q · Destroyed