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 SEA94LA017Accident · No injuriesLimited investigationFinal reportCessna 182R · Tooele, UTAirspeed was not maintained.Oct 15, 1993 · N6503E · Substantial damageNTSB 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.Oct 15, 1993 · N669CP · Substantial damageNTSB 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.Oct 15, 1993 · N61563 · Substantial damageNTSB MIA94LA007Accident · 1 fatalLimited investigationFinal reportCessna 182-P · Orlando, FLThe pilot's improper procedures and his complacency during his attempts to start the engine.Oct 15, 1993 · N20718 · Minor damageNTSB 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.Oct 15, 1993 · N6538T · Substantial damageNTSB 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.Oct 15, 1993 · N150GS · Substantial damageNTSB 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.Oct 15, 1993 · N8020V · DestroyedNTSB 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.Oct 15, 1993 · N5191F · Substantial damageNTSB 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.Oct 14, 1993 · N115FR · DestroyedNTSB 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.Oct 14, 1993 · N1859B · Substantial damageNTSB 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.Oct 14, 1993 · N7079J · DestroyedNTSB CHI94IA017Incident · No injuriesIncident investigationFinal reportPiper PA-24-250 · Thief Rvr Falls, MNFatigue failure of the propeller blade, originating from a corrosion pit.Oct 14, 1993 · N6846P · No damageNTSB 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.Oct 13, 1993 · N6198A · Substantial damageNTSB ANC94T#A01Accident · No injuriesClass 3Final reportPiper PA-18 · Cold Bay, AKOct 13, 1993 · N3874Z · Substantial damageNTSB MIA94WA006Accident · 5 fatalForeign investigationPiper Aerostar 601P · Hog Cay, BahamasOct 12, 1993 · N60LN · DestroyedNTSB MIA94WA005Accident · 2 fatalForeign investigationCessna 402B · Congo Town, Congo - KinshasaOct 12, 1993 · N7093L · DestroyedNTSB LAX94LA011Accident · No injuriesLimited investigationFinal reportBeech C90A · Napa, CAThe dual student's improper use of powerplant controls, and inadequate supervision by the flight instructor (CFI).Oct 12, 1993 · N487JD · Substantial damageNTSB CHI94LA013Accident · No injuriesLimited investigationFinal reportHughes 269A · Coldwater, MIthe fatigue failure of the tailboom support strut attachment lug.Oct 12, 1993 · N7032U · Substantial damageNTSB 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.Oct 12, 1993 · N4788Q · Substantial damageNTSB ATL94LA004Accident · No injuriesLimited investigationFinal reportCessna 172 · Blountville, TNImproper planning/decision by the pilot, which resulted in inadequate fuel and fuel exhaustion.Oct 12, 1993 · N12657 · Substantial damageNTSB 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…Oct 11, 1993 · N7765C · DestroyedNTSB FTW94LA010Accident · Serious injuriesLimited investigationFinal reportEmmert Tierra II · Yukon, OKWas an inadvertent stall. A factor was the gusty tailwind.Oct 11, 1993 · N246RE · Substantial damageNTSB CHI94FA010Accident · 2 fatalField investigationFinal reportCessna R182 · Herbster, WIFailure of the pilot to maintain clearance from trees.Oct 11, 1993 · N6422S · DestroyedNTSB 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.Oct 10, 1993 · N5074V · DestroyedNTSB SEA94LA012Accident · No injuriesLimited investigationFinal reportCessna T-337E · Yamhill, ORThe pilot failed to attain the proper touchdown point. The tailwind was a factor.Oct 10, 1993 · N1244M · Substantial damageNTSB 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.Oct 10, 1993 · N320SE · DestroyedNTSB LAX94LA008Accident · No injuriesLimited investigationFinal reportStinson 108 · Mesa, AZa loose wheel half bolt, due to the inadequate maintenance inspection of the aircraft.Oct 10, 1993 · NC409 · Substantial damageNTSB FTW94FA009Accident · 1 fatalField investigationFinal reportPiper PA-36-285 · Estelline, TXClearance not maintained by the pilot.Oct 10, 1993 · N57577 · DestroyedNTSB 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.Oct 10, 1993 · N738LX · Substantial damageNTSB SEA94LA013Accident · No injuriesLimited investigationFinal reportCessna 172N · Renton, WAThe student pilot's failure to maintain directional control during landing. The crosswind was a factor.Oct 9, 1993 · N7367E · Substantial damageNTSB 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).Oct 9, 1993 · N7020J · DestroyedNTSB 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.Oct 9, 1993 · N6AP · DestroyedNTSB 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.Oct 9, 1993 · N4058A · DestroyedNTSB 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.Oct 9, 1993 · N811E · Substantial damageNTSB 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.Oct 8, 1993 · N9932Q · Substantial damageNTSB 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.Oct 8, 1993 · N5365D · DestroyedNTSB 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.Oct 8, 1993 · N91849 · DestroyedNTSB ANC94LA010Accident · No injuriesLimited investigationFinal reportCessna CE-180 · King Salmon, AKThe pilot-in-command's selection of unsuitable terrain and the berm on the airstrip.Oct 8, 1993 · N2245C · Substantial damageNTSB 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.Oct 8, 1993 · N173K · Substantial damageNTSB SEA94LA016Accident · No injuriesLimited investigationFinal reportCessna 180K · Garfield, WAConnecting rod bolt fatigue.Oct 7, 1993 · N61946 · Substantial damageNTSB SEA94LA010Accident · Minor injuriesLimited investigationFinal reportRobinson R-22B · Marysville, WAThe student pilot's failure to maintain altitude.Oct 7, 1993 · N8072V · DestroyedNTSB 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.Oct 7, 1993 · N781T · Substantial damageNTSB 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.Oct 7, 1993 · N71492 · Substantial damageNTSB 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.Oct 6, 1993 · N6773R · Substantial damageNTSB 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…Oct 6, 1993 · N10GL · DestroyedNTSB 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.Oct 6, 1993 · N95AF · Substantial damageNTSB 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.Oct 6, 1993 · N68108 · DestroyedNTSB 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.Oct 6, 1993 · N8090M · Substantial damageNTSB 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.Oct 6, 1993 · N8339C · Substantial damageNTSB CHI94LA007Accident · Minor injuriesLimited investigationFinal reportBoeing 75N1 · St Paul, MNFailure of the pilot to maintain proper altitude.Oct 6, 1993 · N81235 · Substantial damage