NTSB investigations, 2000
180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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 WHERE year(c.\"eventDate\") = 2000 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 WHERE year(c."eventDate") = 2000 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 LAX00FA101Accident · Minor injuriesField investigationFinal reportCessna 172N · Palm Springs, CAthe failure of both flight crews to see and avoid the other airplane while operating in the traffic pattern, which resulted in a mid-air collision. A contributing factor was the failure of the arriving aircraft to comply with air traffic control requests by…NTSB FTW00FA083Accident · 1 fatalField investigationFinal reportCessna 182M · Mcalester, OKThe failure of both pilots to maintain visual lookout while maneuvering in the traffic pattern.NTSB NYC00LA081Accident · No injuriesLimited investigationFinal reportPiper PA-28-236 · Parkertown, OHThe inadequate visual lookout by the pilots of both airplanes.NTSB FTW00LA082Accident · Minor injuriesLimited investigationFinal reportBeech BE-35K · Houston, TXThe pilot's failure to refuel resulting in fuel exhaustion and a total loss of engine power. Factors were the low ceilings, mist, and the pilot's inability to fly the ILS approach.NTSB CHI00LA073Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Amery, WIthe pilots failure to maintain directional control. Factors to the accident were the icing conditions, the snow and ice covered runway and the snowbank.NTSB CHI00FA071Accident · No injuriesField investigationFinal reportBeech 1900D · Escanaba, MIthe failure of the flightcrew to maintain directional control due to unsafe/hazardous conditions on the runway that was not relayed to them. Factors were the uneven snow covered runway and the snowbank.NTSB ATL00FA026Accident · 1 fatalField investigationFinal reportPiper PA-28-161 · Chamblee, GAThe S76 helicopter pilot's failure to follow ATC landing sequence clearance, which resulted in the PA-28's encounter with the helicopters wake turbulence. A factor was the air traffic controllers clearance procedure.NTSB NYC00LA080Accident · Minor injuriesLimited investigationFinal reportTaylorcraft F19 · West Lafayette, OHwas a delayed decision of the pilot to abort the landing. Factors were the wet runway, and the tail winds that prevailed in the area.NTSB NYC00FA079Accident · 4 fatalField investigationFinal reportBeech 58 · Cynthiana, KYThe pilot's failure to maintain airspeed during a climb, which resulted in a loss of aircraft control.NTSB LAX00LA103Accident · No injuriesLimited investigationFinal reportHughes 369HS · Pacific Ocean (Pacific Ocean)An unknown mechanical malfunction that resulted in a precautionary landing at sea and the subsequent sinking of the helicopter by an ocean swell.NTSB LAX00LA098Accident · Serious injuriesLimited investigationFinal reportFokker FK-28-4000 · Red Bluff, CAthe failure of the passenger to fasten his seat belt without the necessity of being instructed by the flight attendant.NTSB LAX00FA099Accident · 2 fatalField investigationFinal reportCessna 182L · Coulterville, CAThe pilot's attempted flight into known adverse weather after receiving hazardous weather advisories, which resulted in inadvertent flight into instrument meteorological conditions while attempting to maintain VFR conditions on top. The subsequent…NTSB MIA00FA090Accident · 1 fatalField investigationFinal reportBeech 35-P35 · Dayton, TNthe non-instrumented rated pilot elected to takeoff into known adverse weather conditions, which resulted in impact with rising terrain. Factors in this accident were, clouds and low ceilings.NTSB IAD00LA022Accident · No injuriesLimited investigationFinal reportCessna 172 · Norridgewock, MEthe student pilot's loss of directional control during the takeoff roll.NTSB FTW00LA081Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-250 · College Station, TXThe loss of engine power due to fuel system contamination. A factor was the lack of suitable terrain for the forced landing.NTSB NYC00LA077Accident · No injuriesLimited investigationFinal reportCessna 185 · Saratoga Sprngs, NYThe pilot's loss of control of the airplane during the landing.NTSB NYC00IA078Incident · Minor injuriesIncident investigationFinal reportSaab-Scania 340B · Boston, MAThe vehicle driver's inadequate visual lookout.NTSB LAX00FA097Accident · No injuriesField investigationFinal reportBoeing 757-232 · San Salvador, El SalvadorThe pilot's improper flare which resulted in a bounced landing.NTSB DEN00LA051Accident · No injuriesLimited investigationFinal reportMaule M-6-235 · Reserve, NMThe pilot's failure to adequately compensate for wind conditions. A factor was the wind gust.NTSB DCA00WA025Accident · No injuriesForeign investigationBoeing B 727-100 · Luanda, AngolaNTSB CHI00LA069Accident · No injuriesLimited investigationFinal reportBeech A36 · Olathe, KSthe pilots improper use of powerplant controls. A factor in the accident was the plowed farm field.NTSB ATL00LA025Accident · No injuriesLimited investigationFinal reportCessna 152 · Clearwater, FLThe pilot's failure to maintain visual lookout during flight operations under Visual Flight Rules. A factor is that the pilot was not on the airport radio frequency.NTSB IAD00WA020Accident · No injuriesForeign investigationSikorsky CH-3E · Wairoa Gorge, New ZealandNTSB IAD00LA021Accident · 2 fatalLimited investigationFinal reportWood Seawind 3000 · Cumberland Gap, VAThe pilot's continued flight from visual flight rules into instrument meteorological conditions.NTSB DEN00GA050Accident · 2 fatalFinal reportBell OH-58A+ · Woods Cross, UTThe pilot's failure to roll throttle back on (return the power to the normal operating range) during an attempted power recovery from an autorotation, and his subsequent failure to maintain aircraft control.NTSB CHI00FA070Accident · 1 fatalField investigationFinal reportMitsubishi MU-2B-60 · Lewiston, IDthe pilot failed to follow the flight manual procedures and did not engage the Continuous Ignition system resulting in both engines flaming out when the air induction system was blocked with ice. Additional factors to the accident included the hilly terrain,…NTSB MIA00LA089Accident · No injuriesLimited investigationFinal reportBeech 76 · Salisbury, NCThe flight instructors inadequate supervision of a dual student who attempted a go around using one engine which resulted in loss of control and impact with the ground.NTSB CHI00LA067Accident · No injuriesLimited investigationFinal reportBeech V35 · Schaumburg, ILinadequate aircraft preflight by the pilot and fuel consumption calculations not being preformed by the pilot. Factors to the accident were fuel exhaustion, the rocks/boulders, and the high vegetation.NTSB ATL00FA024Accident · 2 fatalField investigationFinal reportMooney M20J · Odessa, FLThe pilot's failure to maintain a safe altitude and his failure to attain the proper touchdown point during landing. A factor was the utility pole.NTSB NYC00IA076Incident · No injuriesIncident investigationFinal reportCessna 182P · Hartford, CTThe pilot's failure to maintain a visual lookout.NTSB MIA00LA091Accident · No injuriesLimited investigationFinal reportBeech F90 · Monroe, GAchafed wiring that resulted in an electrical short which initiated the landing gear retraction cycle when cabin heat was activated, resulting in the main landing gear retracting during taxi.NTSB IAD00LA019Accident · No injuriesLimited investigationFinal reportCessna 172 · Lyndonville, VTthe student pilot's failure to maintain directional control during landing. A factor in the accident was the ditch that ran parallel to the runway.NTSB ANC00LA027Accident · Serious injuriesLimited investigationFinal reportPiper PA-31-T3 · Wales, AKThe pilot's inadequate evaluation of the weather conditions, and his inadvertent flight into adverse weather conditions. Factors in the accident were terrain induced turbulence and a tailwind.NTSB NYC00WA216Accident · No injuriesForeign investigationBeech BE-60 · Halle-Oppin, GermanyNTSB MIA00LA087Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Englewood, FLThe failure of the pilot to retract the flaps from the fully extended position following the last landing resulting in the failure to maintain airspeed and subsequent descent for a forced landing. A contributing factor in the accident was the pilot's…NTSB LAX00LA095Accident · Minor injuriesLimited investigationFinal reportCessna 210E · Glendale, AZthe pilot's attempt to go-around with inadequate altitude and airspeed available, resulting in a power demand that exceeded the capability of the aircraft. The fully extended gear and flaps were factors in this accident.NTSB FTW00FA080Accident · 1 fatalField investigationFinal reportBeech B23 · New Braunfels, TXthe seizure of the engine while maneuvering due to the oil pressure relief valve plug ball seat becoming contaminated with metal. Contributing factors were the inadequate engine maintenance, and the lack of suitable terrain for the forced landing.NTSB CHI00MA066Accident · 3 fatalMajor investigationFinal reportMoravan Z242L · Zion, ILClearance not maintained by the pilot of the other airplane. A factor relating to the accident was the airport control tower's local controller's failure to provide effective sequencing.NTSB CHI00LA064Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Alma, MIthe pilot's inadequate fuel consumption calculation. Factors were the rough terrain, the fence and the exhaustion of the fuel supply.NTSB ANC00LA026Accident · No injuriesLimited investigationFinal reportCessna 180 · Glennallen, AKThe pilot's selection of an unsuitable landing site on a frozen, snow-covered lake. A factor associated with the accident was an area of drifted snow at the landing site.NTSB SEA00LA043Accident · Minor injuriesLimited investigationFinal reportRockwell S-2R · Kahlotus, WAThe pilot's failure to maintain sufficient altitude over, or clearance with, a barbed-wire fence. A factor was the fence.NTSB NYC00LA074Accident · No injuriesLimited investigationFinal reportGrumman American AA1 · Wildwood, NJThe student pilot's failure to maintain directional control. A factor in this accident was the crosswind condition.NTSB MIA00LA086Accident · No injuriesLimited investigationFinal reportCessna 172R · Olive Branch, MSThe student pilot's failure to maintain directional control during landing and the subsequent collision with a taxiway sign and collapsed right main landing gear.NTSB MIA00LA085Accident · No injuriesLimited investigationFinal reportCessna 152 · Louisburg, NCThe improper recovery from the bounced landing by the pilot-in-command for his failure to apply power and inadvertent stall by the pilot-in-command resulting in a hard landing. A contributing factor was the total lack of experience of the pilot-in-command.NTSB LAX00LA253Accident · No injuriesLimited investigationFinal reportCessna 310L · Flagstaff, AZthe fracture across the eyelet of the nose gear retraction rod, which prevented the extension of the nose gear.NTSB LAX00LA096Accident · No injuriesLimited investigationFinal reportCessna 172N · Bermuda Dunes, CAFailure of the student pilot to maintain directional control of the airplane during takeoff.NTSB LAX00FA093Accident · 4 fatalField investigationFinal reportGray Questair Venture · Sylmar, CAThe pilots' inadequate visual lookout in visual conditions and class 'E' airspace. Contributing to the accident were the initial position report location and the approach speed of the Questair.NTSB LAX00FA090Accident · 1 fatalField investigationFinal reportCessna 150J · Redwood City, CAThe pilot's inadequate weather evaluation and continued visual flight into instrument meteorological conditions. Factors were the pilot's improper remedial action and his self-induced pressure.NTSB DEN00TA049Accident · Minor injuriesFinal reportCessna A185F · Loveland, COFailure of the pilot in command to maintain directional control, resulting in an inadvertent ground loop. A factor was the crosswind.NTSB ANC00LA025Accident · No injuriesLimited investigationFinal reportCessna 207 · Tuluksak, AKThe pilot's failure to maintain proper alignment during the takeoff roll. A factor associated with the accident was a soft area of snow on the runway.