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 SEA98LA115Accident · No injuriesLimited investigationFinal reportTracy Avid Mark IV · Coeur D'Alene, IDThe pilot's failure to maintain adequate airspeed.NTSB FTW98LA308Accident · No injuriesLimited investigationFinal reportPiper PA-20-160 · Kemmerer, WYThe pilot's failure to maintain directional control of the airplane, resulting in a ground loop. A factor was the pilot's lack of experience in a conventional landing gear type of airplane.NTSB FTW98LA292Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Lubbock, TXThe loss of engine power due to the collapsed of the engine induction air ducting. Factors were the inadequate maintenance inspection and the lack of suitable terrain for the pilot to execute the forced landing.NTSB DCA98WA070Incident · No injuriesForeign investigationBoeing 737-400 · Brazil, BrazilNTSB CHI98LA239Accident · Minor injuriesLimited investigationFinal reportRobinson R-44 · Cassville, MOThe pilot in command's inadequate preflight planning/preparation and weather evaluation that resulted in flight into adverse weather conditions. Factors to the accident were a preflight briefing service not being used and the transmission wire.NTSB CHI98LA233Accident · Minor injuriesLimited investigationFinal reportWicks FLY Baby · Blissfield, MIthe pilot's misjudging of the fuel supply and his inadequate aircraft preflight. A factor was fuel exhaustion,NTSB ATL98LA088Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Jacksonville, FLThe pilot's failure to manage his fuel properly leading to fuel starvation, a loss of engine power, and the collision with trees and the ground. A factor was his lack of total experience.NTSB IAD98LA074Accident · No injuriesLimited investigationFinal reportAmerican Blimp ABC-A-60 · Lock Haven, PAthe pilot's encounter with unforecasted downdrafts.NTSB FTW98FA291Accident · 1 fatalField investigationFinal reportCessna 140A · Edgewood, TXThe pilot's failure to maintain minimum required airspeed for flight. Factors were the worn fuel line, which separated, and the failure of the maintenance personnel to locate the worn fuel line during the annual inspection.NTSB DCA98WA064Incident · No injuriesForeign investigationBoeing 777 · Tenerife, SpainNTSB CHI98LA235Accident · 1 fatalLimited investigationFinal reportPiper PA-22-108 · Spearfish, SDthe pilots improper preflight planning, which failed to detect the fuel selector positioned on the left fuel tank, which had insufficient fuel, resulting in fuel starvation, and the loss of engine power.NTSB CHI98LA234Accident · No injuriesLimited investigationFinal reportAmerican AA-1TW · Point Lookout, MOthe failure of the tailwheel assembly due to corrosion. A factor associated with the accident was the overload failure of the right main landing gear.NTSB CHI98LA232Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Chillicothe, MOthe improper use of the engine starting procedure. Factors contributing to the accident were the pilot in command's lack of recent experience, the aircraft not being tied down, the utility pole and guy wire.NTSB CHI98LA231Accident · No injuriesLimited investigationFinal reportKerr Startduster TOO · Bay City, MIthe pilot's failure to assure the tailwheel tire had adequate pressure which resulted in his inability to maintain directional control of the airplane during a landing. Factors associated with the accident were the inadequate pressure and the uneven terrain…NTSB ATL98LA089Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Homestead, FLThe pilot's improper flare that resulted in a hard landing and porpoise, and his improper recovery from the bounced landing.NTSB ANC98LA090Accident · No injuriesLimited investigationFinal reportCessna 206G · Aleknagik, AKThe pilot's failure to attain a proper touchdown point during landing. A factor associated with the accident is the presence of a variable wind condition, and the pilot's decision not to perform a go-around.NTSB ANC98LA089Accident · No injuriesLimited investigationFinal reportCessna 185E · Iliamna, AKThe pilot's inadequate compensation for crosswind conditions. Factors associated with the accident were a crosswind and the pilot's lack of recent experience in a tailwheel airplane.NTSB ANC98LA088Accident · No injuriesLimited investigationFinal reportChampion 7GCB · Hope, AKThe pilot's selection of an unsuitable landing/takeoff area. Contributing factors were the stream crossing the airstrip and the embankment.NTSB ANC98LA087Accident · Minor injuriesLimited investigationFinal reportPiper PA-20 · Soldotna, AKThe pilot's inadvertent stall of the airplane.NTSB LAX98FA208Accident · 1 fatalField investigationFinal reportFrandsen Midget Mustang MM-1 · Tracy, CAinadequate maintenance/inspection by the owner/pilot that resulted in an obstructed fuel vent system and a subsequent loss of engine power during takeoff.NTSB FTW98FA290Accident · 1 fatalField investigationFinal reportCessna A188B · Panhandle, TXThe pilot's failure to maintain clearance from the power transmission wires while maneuvering during an aerial application flight.NTSB FTW98FA289Accident · 2 fatalField investigationFinal reportCessna 150H · Weslaco, TXFailure to maintain adequate airspeed by one of the pilot's on board. A factor was the low altitude.NTSB DCA98WA061Accident · 5 fatalForeign investigationBell 212 · NigeriaNTSB ANC98LA086Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Anchorage, AKThe pilot's inadvertent activation of the brakes during the takeoff roll, and subsequent loss of control.NTSB SEA98LA114Accident · No injuriesLimited investigationFinal reportCessna 182P · Chico Hot Spgs., MTThe pilot's inadequate remedial action while attempting to compensate for a change in crosswind velocity. Factors include a crosswind, hills near the runway, and high vegetation (weeds) near the runway.NTSB MIA98LA191Accident · No injuriesLimited investigationFinal reportCessna 152 · Columbia, SCThe pilot's delay in initiating a go-around, which resulted in an inflight collision with power lines.NTSB LAX98LA217Accident · No injuriesLimited investigationFinal reportAeronca Chief 65-CA · Phoenix, AZThe failure of the pilot to maintain directional control of the aircraft during the landing rollout.NTSB LAX98LA216Accident · No injuriesLimited investigationFinal reportCessna 180H · Ocotillo Wells, CAFailure of the left main landing gear due to a probable hard landing at an undetermined time.NTSB LAX98IA218Incident · No injuriesIncident investigationFinal reportAero Commander 681B · Reno, NVThe failure and separation of the first and third stage turbine disks for undetermined reasons.NTSB CHI98LA228Accident · No injuriesLimited investigationFinal reportCessna 172N · Stone Lake, WIthe lack of effective braking due to hydroplaning. Contributing factors to the accident were the trees off the end of the runway that made a go-around not possible and the ditch off the end of the runway.NTSB CHI98LA225Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Flushing, MIwas a delayed go-around maneuver by the pilot. Factors associated with this accident were the pilot misjudging his final approach altitude and glide path, having inadequate altitude to clear the trees at the end of the runway, and inadequate training on how…NTSB SEA98LA113Accident · Serious injuriesLimited investigationFinal reportPiper PA-18 · Big Creek, IDThe pilot's failure to maintain airspeed while maneuvering to an emergency landing, resulting in an inadvertent stall/mush into the terrain. A contributing factor was the high density altitude.NTSB SEA98LA112Accident · No injuriesLimited investigationFinal reportAviat Husky A-1 · Triple R Ranch, MTThe pilot's misjudgment of distance and his failure to initiate a go-around. A factor was the high density altitude.NTSB NYC98LA137Accident · No injuriesLimited investigationFinal reportCessna 152 · Pottstown, PAThe student pilot's excessive application of the right brake, resulting in a ground loop.NTSB NYC98LA135Accident · Serious injuriesLimited investigationFinal reportTaylorcraft BC12-65 · West Buxton, MEfailure of the pilot to see-and-avoid power lines (inadequate visual lookout), as he was approaching to make a water landing on a river.NTSB FTW98LA285Accident · Serious injuriesLimited investigationFinal reportCessna 150G · Uvalde, TXThe pilot's improper use of the flaps which resulted in an inadvertent stall during the initial takeoff climb. Factors were his lack of recent experience in the make and model of airplane and the high density altitude.NTSB FTW98GA286Accident · 2 fatalFinal reportLockheed SP-2H · Reserve, NMFailure of the copilot to maintain both lateral and vertical clearance from the trees, and failure of the captain to provide adequate supervision of the flight.NTSB FTW98FA287Accident · 1 fatalField investigationFinal reportCessna 175 · Clovis, NMThe pilot's failure to maintain adequate obstacle clearance and the proper landing glide path. Also causal was his loss of aircraft control during an attempted go-around. Factors were the dark night light conditions, the pilot's recent lack of sleep, and the…NTSB CHI98LA227Accident · Minor injuriesLimited investigationFinal reportCommonwealth 185 · Oregon, WIthe improper adjustment of the carburetor by an unqualified person. Factors to the accident were the annual inspection not being complied with and the lack of recent experience of the pilot.NTSB CHI98LA226Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Osceola, WIthe student pilot's incomplete preflight, and the instructor pilot's inadequate supervision of the student's preflight. Factors were the fuel contaminated with water, and the roadway encountered during the forced landing rollout.NTSB SEA98LA111Accident · No injuriesLimited investigationFinal reportKoster Murphy Rebel · Arlington, WAThe pilot/builder's attachment inadequate installation of the aileron control pushrods to the control stick assembly, resulting in the ailerons deflecting in a direction opposite of the input applied by the pilot. Also causal was the pilot's inadequate…NTSB SEA98LA106Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Oakdale, WAA fatigue failure of the number three cylinder exhaust rocker box assembly, compromising the ability of the exhaust valve to operate. Factors include a ditch at the end of the runway.NTSB MIA98LA190Accident · Serious injuriesLimited investigationFinal reportAviat A-1A · Daytona Beach, FLThe pilot's failure to maintain airspeed, which resulted in a stall. A contributing factor was the pilot's delay in initiating remedial action.NTSB MIA98LA189Accident · Serious injuriesLimited investigationFinal reportCessna 150G · Perry, FLThe improper repair of the no. 2 engine cylinder, which resulted in the loss of engine power.NTSB LAX98LA215Accident · No injuriesLimited investigationFinal reportZimmerman Kitfox 4-1200 · Fountain Hills, AZThe failure of the pilot to maintain directional control during the landing roll in a crosswind.NTSB LAX98LA214Accident · No injuriesLimited investigationFinal reportCessna 172 · Flagstaff, AZOil system contamination with an unidentified metal substance that traveled through the oil system and blocked the number 4 main bearing and number 6 connecting rod bearing oil ports, resulting in oil starvation and failure of the engine. The source of the…NTSB DCA98WA062Incident · No injuriesForeign investigationBoeing 737-800 · Munich, GermanyNTSB DCA98WA060Accident · Minor injuriesForeign investigationSchweizer 269D · NetherlandsNTSB CHI98LA282Accident · No injuriesLimited investigationFinal reportCessna 310R · Cahokia, ILThe collapse of the left main landing gear during landing roll for undetermined reasons.NTSB CHI98LA229Accident · No injuriesLimited investigationFinal reportAeronca 7BCM · Portland, NDthe pilot's not maintaining directional control. Factors were landing on a roadway and tall grass.