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 SEA94LA017Accident · No injuriesLimited investigationFinal reportCessna 182R · Tooele, UTAirspeed was not maintained.NTSB NYC94LA010Accident · Minor injuriesLimited investigationFinal reportSchlappi RV3 · Hatfield, MAThe pilot misjudged his distance and altitude which resulted in an undershoot of the runway. A factor was his delay in intiating a go around.NTSB NYC94LA009Accident · 1 fatalLimited investigationFinal reportNorth American SNJ-2 · Skaneateles, NYThe pilot's inadequate preflight preparation which failed to adequately secure cargo, resulting control interference. A factor was the overgross weight condition of the airplane.NTSB MIA94LA007Accident · 1 fatalLimited investigationFinal reportCessna 182-P · Orlando, FLThe pilot's improper procedures and his complacency during his attempts to start the engine.NTSB LAX94LA014Accident · No injuriesLimited investigationFinal reportCessna 150 · Daggett, CAthe pilot's poor fuel consumption calculations which culminated in engine losing power due to fuel exhaustion. The soft desert terrain was a factor in this accident.NTSB LAX94LA013Accident · No injuriesLimited investigationFinal reportCessna 150L · Van Nuys, CAthe pilot's poor preflight planning/preparation and fuel consumption calculations. Fuel exhaustion is a factor in this accident.NTSB FTW94LA012Accident · Serious injuriesLimited investigationFinal reportCessna A188 · Burleson, TXWas the pilot's inadvertent entry into a stall. A factor was his abrupt maneuvering of the airplane at low altitude.NTSB FTW94LA011Accident · No injuriesLimited investigationFinal reportCessna 172F · Co. Springs, COAn encounter with wake turbulence during the landing flare. A factor was lack of total pilot experience.NTSB SEA94FA014Accident · 2 fatalField investigationFinal reportCessna 172P · Kelso, WAThe pilot's failure to follow the published missed approach procedure. Factors in the accident were: the weather and mountainous terrain.NTSB NYC94LA012Accident · Minor injuriesLimited investigationFinal reportLuscombe T8F · Vernon, NJThe pilot's inadequate preflight inspection, which failed to detect an unsecured dipstick, resulting in oil starvation and the loss of engine power.NTSB LAX94LA012Accident · Minor injuriesLimited investigationFinal reportPiper PA-31 · Hilo, HIthe failure of the right engine's magnetos for undetermined reasons and the resulting overtemperature of the remaining left engine.NTSB CHI94IA017Incident · No injuriesIncident investigationFinal reportPiper PA-24-250 · Thief Rvr Falls, MNFatigue failure of the propeller blade, originating from a corrosion pit.NTSB FTW94LA016Accident · No injuriesLimited investigationFinal reportBeech A36 · Tomball, TXWas the pilot's disregard for and continued descent below mda and his delay in executing a go around.NTSB ANC94T#A01Accident · No injuriesClass 3Final reportPiper PA-18 · Cold Bay, AKNTSB MIA94WA006Accident · 5 fatalForeign investigationPiper Aerostar 601P · Hog Cay, BahamasNTSB MIA94WA005Accident · 2 fatalForeign investigationCessna 402B · Congo Town, Congo - KinshasaNTSB LAX94LA011Accident · No injuriesLimited investigationFinal reportBeech C90A · Napa, CAThe dual student's improper use of powerplant controls, and inadequate supervision by the flight instructor (CFI).NTSB CHI94LA013Accident · No injuriesLimited investigationFinal reportHughes 269A · Coldwater, MIthe fatigue failure of the tailboom support strut attachment lug.NTSB CHI94LA012Accident · No injuriesLimited investigationFinal reportCessna A188B · Wall, SDFailure of the pilot to maintain directional control, which resulted in an inadvertent ground swerve. A factor related to the accident was: the pilot's lack of familiarity with the type (make and model) of airplane.NTSB ATL94LA004Accident · No injuriesLimited investigationFinal reportCessna 172 · Blountville, TNImproper planning/decision by the pilot, which resulted in inadequate fuel and fuel exhaustion.NTSB LAX94FA009Accident · 2 fatalField investigationFinal reportNorth American T-6G · Green Valley, CAthe CFI's failure to maintain the proper altitude while flying over mountainous terrain, and his inadvertent flight into instrument weather conditions. Contributing factors were the CFI's improper in-flight decision to fly at the low altitude and his…NTSB FTW94LA010Accident · Serious injuriesLimited investigationFinal reportEmmert Tierra II · Yukon, OKWas an inadvertent stall. A factor was the gusty tailwind.NTSB CHI94FA010Accident · 2 fatalField investigationFinal reportCessna R182 · Herbster, WIFailure of the pilot to maintain clearance from trees.NTSB SEA94LA015Accident · 1 fatalLimited investigationFinal reportVarga 2150A · Burns, ORPoor in-flight planning/decision and an inadvertent stall/spin. A factor to the accident was an excessive pull-up.NTSB SEA94LA012Accident · No injuriesLimited investigationFinal reportCessna T-337E · Yamhill, ORThe pilot failed to attain the proper touchdown point. The tailwind was a factor.NTSB MIA94LA004Accident · Serious injuriesLimited investigationFinal reportEhlers Lancair 320 · Bay St. Louis, MSThe pilot-in-command's failure to maintain airspeed resulting in an in flight loss of control (stall/spin) and subsequent in flight collision with trees and terrain.NTSB LAX94LA008Accident · No injuriesLimited investigationFinal reportStinson 108 · Mesa, AZa loose wheel half bolt, due to the inadequate maintenance inspection of the aircraft.NTSB FTW94FA009Accident · 1 fatalField investigationFinal reportPiper PA-36-285 · Estelline, TXClearance not maintained by the pilot.NTSB CHI94LA011Accident · No injuriesLimited investigationFinal reportCessna 172 · Independence, MOThe pilot's misjudgment of distance, altitude, and speed on final approach to land, and failure to maintain obstacle clearance from the vehicle. The proximity of the vehicle to the approach path was a related factor.NTSB SEA94LA013Accident · No injuriesLimited investigationFinal reportCessna 172N · Renton, WAThe student pilot's failure to maintain directional control during landing. The crosswind was a factor.NTSB NYC94LA008Accident · 1 fatalLimited investigationFinal reportFeatherston Titan Tornado · Mechanicsville, VAFailure of the pilot to correct the descent. Factors related to the accident were: the light conditions at dusk, impairment of the pilot from use of a medication (prescription drug), and possible lack of visual ques (pilot's visual perception).NTSB NYC94FA007Accident · 1 fatalField investigationFinal reportBeech A36 · Topsfield, MAFailure of the pilot to follow the published IFR procedure, and his failure to correct a spiral after becoming spatially disoriented.NTSB FTW94FA008Accident · 2 fatalField investigationFinal reportBalloon Works FIREFLY-7 · Albuquerque, NMThe p[ilot's improper decision to attempt continued flight under the existing wind conditions. The adverse wind was a contributing factor.NTSB ANC94LA009Accident · No injuriesLimited investigationFinal reportDouglas C-54GDC · Point Lay, AKThe pilot-in-command's failure to perform proper preflight planning by not computing the required landing runway length.NTSB SEA94LA011Accident · No injuriesLimited investigationFinal reportCessna 172M · Longbranch, WAThe instructor pilot's failure to follow procedures. Factors include carburetor icing conditions and soft terrain in the landing area.NTSB LAX94FA007Accident · 1 fatalField investigationFinal reportCessna 172N · Sedona, AZthe pilot's decision to continue VFR at an improper altitude into mountainous terrain at night and the inadvertent encounter with clouds along the route. Self-induced pressure due to a low fuel state contributed to the accident.NTSB LAX94FA006Accident · 2 fatalField investigationFinal reportCessna 182M · Seligman, AZthe separation of the carburetor float and needle valve from the upper half of the carburetor bowl, due to improper installation of the float kit.NTSB ANC94LA010Accident · No injuriesLimited investigationFinal reportCessna CE-180 · King Salmon, AKThe pilot-in-command's selection of unsuitable terrain and the berm on the airstrip.NTSB ANC94LA007Accident · No injuriesLimited investigationFinal reportHelio H-391-B · Beaver Creek, AKThe pilot's failure to maintain the required airspeed during the emergency descent as published in the pilot's manual. A factor is the loss of engine power for undetermined reasons.NTSB SEA94LA016Accident · No injuriesLimited investigationFinal reportCessna 180K · Garfield, WAConnecting rod bolt fatigue.NTSB SEA94LA010Accident · Minor injuriesLimited investigationFinal reportRobinson R-22B · Marysville, WAThe student pilot's failure to maintain altitude.NTSB MIA94LA003Accident · No injuriesLimited investigationFinal reportDouglas DC-3C · San Juan, PRPartial failure of a wing rib due to exfoliation corrosion and inadequate inspection of the aircraft by company maintenance personnel.NTSB CHI94LA008Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Bristol, INthe pilot's abrupt maneuver (intentional swerve) and main gear collapse during the landing roll on a short grass strip.NTSB NYC94LA006Accident · No injuriesLimited investigationFinal reportCessna T210F · Frederick, MDThe mechanic's inadequate inspection and the pilot's inadequate preflight inspection which failed to detect water-contaminated fuel, resulting in a loss of engine power and a forced landing.NTSB NYC94FA004Accident · 2 fatalField investigationFinal reportPiper PA-23-250 · East Hampton, NYInadvertent feathering of both propellers by the student pilot, which resulted in a loss of power, and failure (or inability) of the instructor pilot (CFI) to attain remedial action. A factor related to the accident was: the student pilot's habit…NTSB MIA94LA002Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Opa-Locka, FLImproper servicing of three of the four main landing gear dampers by company maintenance personnel, and innadequate remedial action by the pilot as ground resonance began.NTSB FTW94LA007Accident · No injuriesLimited investigationFinal reportCessna 152 · San Angelo, TXWas malfunction of the throttle control push/pull rod and cable. A factor was unsuitable terrain for the forced landing.NTSB FTW94LA006Accident · No injuriesLimited investigationFinal reportCessna 310I · Southlake, TXAircraft control not maintained by the private pilot receiving instruction. Factors were rough runway, runway edge lights inoperative, dark night conditions, brakes restricted due to an out of rig rudder system, and inadequate CFI supervision.NTSB CHI94LA019Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Allendale, MIImproper in-flight planning/decision by the pilot, after encountering unfavorable winds and a low fuel level, which resulted in fuel exhaustion. The unfavorable wind was a related factor.NTSB CHI94LA007Accident · Minor injuriesLimited investigationFinal reportBoeing 75N1 · St Paul, MNFailure of the pilot to maintain proper altitude.