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 CHI94LA025Accident · No injuriesLimited investigationFinal reportCessna 150M · Franklin, WIFailure of the instructor pilot (CFI) to use carburetor heat during the simulated engine failure, which resulted in carburetor ice and loss of engine power. Factors related to the accident were: carburetor icing conditions and the crop in the emergency…Oct 26, 1993 · N9259U · Substantial damageNTSB CHI94LA024Accident · 1 fatalLimited investigationFinal reportPiper PA-28-181 · Woonsocket, SDthe pilot misjudging the airplane's clearance under the wires. Factors related to the accident were the performance of a low pass and the wires which were contacted.Oct 26, 1993 · N39952 · DestroyedNTSB NYC94LA022Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Centreville, MDThe loss of engine power for undetermined reasons.Oct 25, 1993 · N16493 · DestroyedNTSB FTW94LA020Accident · No injuriesLimited investigationFinal reportBurkhart Grob G103 · San Antonio, TXThe pilot's failure to maintain a visual lookout. Factors were: inadequate altitude and distracted attention.Oct 25, 1993 · N94BG · Substantial damageNTSB FTW94LA019Accident · Minor injuriesLimited investigationFinal reportBell 206B · High Island 467Were the pilot's inadequate preflight inspection and his failure to remove all of the aircraft tie-downs.Oct 25, 1993 · N22841 · Substantial damageNTSB ATL94LA009Accident · No injuriesLimited investigationFinal reportBell 47G2 · Billingsley, ALThe pilot's improper vertical liftoff which resulted in dynamic roll-over and the main rotor's impact with the ground.Oct 25, 1993 · N866Z · Substantial damageNTSB NYC94LA026Accident · No injuriesLimited investigationFinal reportPiper PA-602P · Falls Of Rough, KYThe pilot's inadequate visual lookout prior to entering the runway, resulting in a taxi off the runway to avoid conflict, onto soft terrain, and the subsequent collapse of the landing gear.Oct 24, 1993 · N6891M · Substantial damageNTSB NYC94LA021Accident · Minor injuriesLimited investigationFinal reportPiper PA-34-200 · Bowling Green, OHThe flight instructor's inadequate supervision of an attempted go-around by the student pilot which resulted in a loss of control and subsequent impact with the terrain. Factors were noncompliance with published procedures.Oct 24, 1993 · N2874T · Substantial damageNTSB NYC94LA020Accident · Serious injuriesLimited investigationFinal reportCessna 182H · Griswold, CTThe pilot's inadequate compensation for wind conditions during takeoff, and the subsequent loss of control and collision with trees. A factor related to the accident were the adverse winds.Oct 24, 1993 · N2111W · DestroyedNTSB MIA94LA011Accident · Minor injuriesLimited investigationFinal reportCessna AT188B · Zellwood, FLPartial loss of engine power for undetermined reasons.Oct 24, 1993 · N731MF · DestroyedNTSB LAX94LA023Accident · No injuriesLimited investigationFinal reportCessna 172 · Murrieta, CAThe unexpected windsheer that was encountered on final approach. The surrounding mountain/hilly terrain was a factor in this accident.Oct 24, 1993 · N96353 · Substantial damageNTSB LAX94LA022Accident · Minor injuriesLimited investigationFinal reportBeech B35 · Indian Springs, NVFailure of the pilot to properly operate the airplane's fuel selector, which resulted in fuel starvation, and his improper emergency procedure for restarting the engine. A factor related to the accident was: the pilot's lack of experience in this make and…Oct 24, 1993 · N5005C · Substantial damageNTSB FTW94LA017Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Woodville, TXFailure of the pilot in command to maintain control of the aircraft during an aborted landing.Oct 24, 1993 · N317BB · Substantial damageNTSB CHI94LA023Accident · No injuriesLimited investigationFinal reportCessna 140 · Frankenmuth, MIImproper use of the mixture control by the pilot. Factors related to the accident were: the similarity of shape, size, and color of the mixture and carburetor heat controls and the terrain condition (with crop) in the emergency landing area.Oct 24, 1993 · N73003 · Substantial damageNTSB CHI94LA021Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Byron, WIthe pilot's inaccurate fuel consumption calculations which resulted in his not refueling during the flight. A factor related to the accident was the pilot's failure to maintain proper airspeed during the forced landing.Oct 24, 1993 · N5390B · DestroyedNTSB NYC94LA018Accident · No injuriesLimited investigationFinal reportCessna 170 · Williamstown, NJFatigue failure of the gear axle which resulted in the collapse of the left main gear.Oct 23, 1993 · N3975V · Substantial damageNTSB NYC94LA017Accident · Minor injuriesLimited investigationFinal reportBeech 77 · Littleton, MAThe flight instructor's inadequate in-flight decision in the selection of the simulated forced landing area, and his delay in initiating a go around which resulted in the airplane colliding with trees.Oct 23, 1993 · N67197 · Substantial damageNTSB NYC94LA013Accident · Serious injuriesLimited investigationFinal reportCessna C-150 · Cynthiana, KYThe pilot's abrupt control of the airplane on short final to the runway, with the flaps retracted, which resulted in an inadvertent stall and the subsequent collision with the trees. A factor in this accident was the poor judgement of the student pilot to go…Oct 23, 1993 · N704US · DestroyedNTSB LAX94LA024Accident · No injuriesLimited investigationFinal reportCessna 150K · California City, CAFailure of maintenance personnel to assure that the nose wheel axle was properly secured during previous maintenance.Oct 23, 1993 · N6067G · Substantial damageNTSB ATL94LA008Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Lexington, NCThe pilot's failure to maintain directional control during a crosswind landing. A factor was the crosswind condition.Oct 23, 1993 · N9778C · Substantial damageNTSB SEA94LA019Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Hamilton, MTThe pilot's improper recovery from a bounced landing, and failure to maintain directional control of the airplane. Factors related to the accident were: the pilot's improper flare for landing, the resultant porpoise, and the ditch near the side of the runway.Oct 22, 1993 · N3568M · Substantial damageNTSB SEA94FA018Accident · 1 fatalField investigationFinal reportCessna 172K · North Bend, ORLoss of control while in flight due to pilot incapacitation from atherosclerotic heart disease.Oct 22, 1993 · N79405 · DestroyedNTSB NYC94LA016Accident · No injuriesLimited investigationFinal reportBeech 58 · Millville, NJthe pilot's inadvertent actuation of the landing gear lever during the landing roll, resulting in the retraction of the landing gear on the runway.Oct 22, 1993 · N13AK · Substantial damageNTSB NYC94LA015Accident · Minor injuriesLimited investigationFinal reportCessna 310L · Tewksbury, MAwas an improperly planned approach, and excessive compensation for the winds by the pilot which resulted in an overrun, and on ground collision with a fence and vehicle. A factor was the gusty crosswinds.Oct 22, 1993 · N3328X · Substantial damageNTSB MIA94LA010Accident · Serious injuriesLimited investigationFinal reportBoeing 767-300 · Atlantic Ocean (Atlantic Ocean)Encounter with unforecasted weather (moderate turblence) resulting in injury to three passengers.Oct 22, 1993 · N649UA · No damageNTSB LAX94LA021Accident · No injuriesLimited investigationFinal reportBeech 76 · Scottsdale, AZthe flight instructor's failure to adequately supervise the flight, follow proper procedures/directives regarding leaning and clearing the idling engine, and his delay in applying power to the idling engine. The fouled spark plugs were a factor in this…Oct 22, 1993 · N5148M · Substantial damageNTSB FTW94LA029Accident · No injuriesLimited investigationFinal reportCessna 210 · Monte Vista, COFailure by the pilot in command to follow procedures and directives to lower the landing gear prior to landing.Oct 22, 1993 · N9653T · Substantial damageNTSB FTW94LA018Accident · No injuriesLimited investigationFinal reportCessna 150L · Athens, TXPilot's failure to maintain directional control due to improper compensation for the wind conditions.Oct 22, 1993 · N17056 · Substantial damageNTSB FTW94LA015Accident · Minor injuriesLimited investigationFinal reportBeech A36TC · Pueblo, COA complete, non mechanical failure of the power plant for unknown reasons. A factor was the lack of suitable terrain for the forced landing.Oct 22, 1993 · N321TJ · Substantial damageNTSB CHI94LA022Accident · No injuriesLimited investigationFinal reportHiller UH12E · Sioux Rapids, IAthe Pilot in Command failed to maintain clearance with the terrain while proceeding up an upslope.Oct 22, 1993 · N4026S · DestroyedNTSB CHI94LA020Accident · Serious injuriesLimited investigationFinal reportCessna 150H · Kansas City, MOLoss of power for an undetermined reason, and the pilot initiating the flight with a rough running engine. Factors related to the accident were: the building and the lack of suitable terrain for a forced landing.Oct 22, 1993 · N23487 · DestroyedNTSB ATL94FA007Accident · 4 fatalField investigationFinal reportBeech S-35 · Carrollton, GAWas the pilot's failure to maintain control of the airplane during a missed approach which resulted in a stall. A factor was the pilot's failure to follow IFR procedures.Oct 22, 1993 · N8688Q · DestroyedNTSB CHI94LA028Accident · No injuriesLimited investigationFinal reportCessna 182 · Belleville, MIwas wind information not used by the pilot-in-command and a resultant exceeding of the airplane's performance capabilities.Oct 21, 1993 · N6353A · DestroyedNTSB ANC94LA013Accident · No injuriesLimited investigationFinal reportPiper PA-32-301 · Karluk, AKThe selection of unsuitable terrain for landing.Oct 20, 1993 · N4327P · Substantial damageNTSB NYC94FA014Accident · 1 fatalField investigationFinal reportMcdonnell Douglas 369E · Richfield, OHAn in flight collision with power lines while the pilot was maneuvering the helicopter at a low altitude. A factor in this accident was reduced visibility due to foggy weather conditions.Oct 19, 1993 · N1605Z · DestroyedNTSB LAX94LA019Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Arvin, CAthe loss of power for undetermined reasons.Oct 19, 1993 · N7501K · Substantial damageNTSB LAX94IA018Incident · No injuriesIncident investigationFinal reportAirbus Industrie A-300-605R · Los Angeles, CAa separation of the number 6 stage high pressure compressor disk for an undetermined reason.Oct 19, 1993 · N41063 · Minor damageNTSB LAX94LA017Accident · Serious injuriesLimited investigationFinal reportAerospatiale SA-315 · Beckwourth, CAwas the worn collective servo causing a hydraulic lock and not allowing the pilot to lower the collective. This condition caused the main rotor blades rpm to decay.Oct 18, 1993 · N49511 · Substantial damageNTSB LAX94LA016Accident · Minor injuriesLimited investigationFinal reportRobinson R-22 Beta · Sunland, CAthe CFI's poor inflight planning/decision and failure to follow normal procedures. The tailwind was a factor in this accident.Oct 18, 1993 · N192KC · Substantial damageNTSB FTW94FA014Accident · 4 fatalField investigationFinal reportPiper PA-28-140 · Texarkana, ARThe pilot's continued VFR flight into instrument meteorological conditions. Factors that contributed to the accident were: the pilot's failure to obtain a weather briefing, the existing weather, his lack of instrument flying experience, and the dark night…Oct 18, 1993 · N98143 · DestroyedNTSB NYC94FA011Accident · 2 fatalField investigationFinal reportCessna 310Q · Tiro, OHLoss of aircraft control for an undetermined reason, and subsequent flight that resulted in the stress limits of the airplane being exceeded and airframe failure.Oct 17, 1993 · N1972D · DestroyedNTSB MIA94LA009Accident · Serious injuriesLimited investigationFinal reportGrumman American AA-5B · Fort Myers, FLImproper decision by the other person (pilot's mother) to go to the airplane, while the pilot was making checks in preparation for flight, and her failure to identify the hazardous condition (turning propeller).Oct 17, 1993 · N28930 · Minor damageNTSB MIA94FA008Accident · Serious injuriesField investigationFinal reportBeech 60 · Miami, FLInadequate preflight by the pilot, and his failure to assure that proper maintenance/annual inspection was attained. Factors related to the accident were: water and other contamination in the fuel supply, lack of continuity in two ignition leads, loose left…Oct 17, 1993 · N7131D · Substantial damageNTSB ATL94FA006Accident · 2 fatalField investigationFinal reportMooney M20B · Bethpage, TNThe pilot's VFR flight into IMC, and his failure to maintain aircraft control. Factors were the pilot's failure to use a preflight briefing service, and the low ceilings and fog at the accident site.Oct 17, 1993 · N74724 · DestroyedNTSB MIA94LA012Accident · No injuriesLimited investigationFinal reportCessna 172M · Culebra, PRThe poor in-flight decision of the pilot-in-command to bank the airplane while flying low level instead of climbing to avoid collision with a bird. Contributing to the accident was the pilot's failure to maintain clearance from the water.Oct 16, 1993 · N16582 · Substantial damageNTSB LAX94LA015Accident · 1 fatalLimited investigationFinal reportTaylorcraft BC12-D · Yuma, AZa failure of the pilot-in-command to maintain adequate airspeed and subsequent inadvertent stall while maneuvering the airplane. Contamination of the fuel in the carburetor that produced a partial power loss was a factor in the accident.Oct 16, 1993 · N94981 · DestroyedNTSB FTW94LA013Accident · No injuriesLimited investigationFinal reportCessna 172K · Jacksonville, TXThe pilot's failure to follow proper emergency procedures to troubleshoot the electrical system. A factor was an electrical system irregularity of an undetermined nature.Oct 16, 1993 · N7825T · Substantial damageNTSB CHI94FA018Accident · 5 fatalField investigationFinal reportPiper PA-32R-300 · Atkinson, NEthe instrument rated commercial pilot's failure to maintain adequate clearance from terrain/obstructions during the initial climb after takeoff. Related factors are the weather conditions (fog) and the pilot's failure to maintain the proper rate of climb.Oct 16, 1993 · N4147Q · DestroyedNTSB ATL94LA005Accident · Minor injuriesLimited investigationFinal reportMooney M20E · Maryville, TNFailure of the pilot to maintain airspeed control, which resulted in a low altitude stall.Oct 16, 1993 · N6823V · Substantial damageNTSB ANC94FA011Accident · 1 fatalField investigationFinal reportCessna 207 · Kenai, AKThe pilot's failure to maintain adequate altitude for terrain clearance. Factors which contributed to the accident were: the pilot's lack of usual sleep, the night light condition and hilly terrain.Oct 16, 1993 · N208SC · Destroyed