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 ANC88LA124Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Talkeetna, AKThe pilot stated that during the takeoff roll and initial climb from the gravel bar, he lost directional control of the airplane causing the airplane to stall, then the airplane ground looped.NTSB ANC88LA123Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Fairbanks, AKThe airplane was on a climbout at approximately 1000 to 1200 feet m.s.l. when the engine quit and the pilot encountered an engine fire. The pilot elected to go back to the airport. The airplane crashed on the taxiway, and the airplane was substantially…NTSB ANC88LA122Accident · No injuriesLimited investigationFinal reportHelio H-295 · Anchorage, AKDuring the takeoff roll on the runway at approximately 20 to 25 mph the pilot lost directional control of the airplane. The airplane looped to the right.NTSB SEA88LA168Accident · Serious injuriesLimited investigationFinal reportCessna 180B · Dixie, IDWhile on final apch to land at the high alt arpt, the plt elected to go around & land at a slower speed. He rprtd that as he neared the rwy on the 2nd apch, the acft enctrd a sudden wind shear, which caused it to drop & bank to the left. Subsequently, the…NTSB NYC88LA233Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Parker City, PAThe purpose of the flt was to perform landings at some nearby apts to prepare the student for an upcoming check flt. Landings were completed at two apts and the PIC, an atp/cfi, requested radar vectors to another apt. Approach control was unable to find the…NTSB MIA88LA264Accident · Minor injuriesLimited investigationFinal reportPiper PA-28 · Orlando, FLThe plt had rented the fully fueled aircraft from an FBO at orl which has hard surfaced 4600 & 6000 ft rwys. He flew to a 130 ft MSL arpt with a 2430 ft grass rwy & picked up his wife for a xc flt. He stated that the acft performed normally during the 10 min…NTSB LAX88FAMS3Accident · 3 fatalMissing aircraftFinal reportCessna 172P · Kauai, HIThe pilot departed for honolulu, HI after flying for 3 hours, 45 minutes without refueling. The flight to honolulu takes 1 hour. The airplane has a full fuel endurance of four hours. It disappeared from navy radar 25 miles southeast of Kauai. Acft wreckage…NTSB FTW88FA160Accident · 4 fatalField investigationFinal reportCessna 170A · El Paso, TXPilot's impairment due to the influence of alcohol.NTSB DEN88LA198Accident · Serious injuriesLimited investigationFinal reportCessna 150F · Peyton, CONTSB ATL88LA244Accident · Minor injuriesLimited investigationFinal reportCessna 177RG · Berkeley, KYThe plt reported that he departed with 6 hrs of fuel on board. He encountered low ceilings while en route, and flew at 3-500 ft AGL to maintain VFR. About 3 hrs & 15 minutes after departure, the engine sputtered and lost power. The plt made a forced ldg in…NTSB LAX88LA305Accident · No injuriesLimited investigationFinal reportCessna 150J · Santa Ynez, CAThe pilot stated that while en route, the airplane's engine began to run rough. He turned on the carburetor heat. The engine returned to normal operation. The pilot turned off the carburetor heat. The engine again ran rough then lost all power. The pilot…NTSB LAX88FA306Accident · 1 fatalField investigationFinal reportPiper PA-28-161 · Temecula, CAFailure of the pilot to properly initiate a go-around during an aborted landing. The loss of directional control during the landing, failure to return to the runway for the aborted takeoff, and not establishing the proper rate of climb due to high density…NTSB LAX88DVA14Accident · Minor injuriesFinal reportAyres S2R-T34 · Five Points, CAPlt was engaged in aerial application and had been overflying power lines. On last pass, plt elected to fly beneath power lines, struck bracing wire between poles with vertical fin, disabling elevator. The acft crashed nose down in a field in an uncontrolled…NTSB DEN88LA197Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-260C · Hamilton, MTThe private plt was descending to the destination arpt at the conclusion of a 3.5 hr x-country flight. The plt said he selected the right main fuel tank and flew until the 'fuel was low to the point of exhaustion.' During a right turn, with the gear extended,…NTSB CHI88LA229Accident · No injuriesLimited investigationFinal reportGrumman AA-5B · Schaumburg, ILDuring an attempted night landing at an airport with inoperative pilot-controlled runway lights, the pilot made a series of low passes (approximately 6 passes) before trying to land. The aircraft collided with the top of a tree located slightly to the left of…NTSB NYC88LA232Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Windham, CTThe student pilot said she heard a popping sound during the takeoff roll and almost instantaneously the door came open. She tried to close the door and when that failed she attempted to abort. She retarded the throttle and attempted braking but it was not…NTSB NYC88LA231Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Mansfield, MAThe acft, with a CFI and student on board, had just made a touch and go landing and was about one mile fm the arpt, climbing to cruise, when the eng lost power. It was dark and the pilot attempted a landing on a state highway. The acft collided with a traffic…NTSB MKC88LA167Accident · Serious injuriesLimited investigationFinal reportSwearingen SA-226 · Emporia, KSWhile cruising at 17,000 ft, the 1st officer's rgt window panel failed & blew outward. A cabin decompression occurred & the copilot was seriously injured. The captain immediately descended to 10,000 ft & continued to their destination where an otherwise…NTSB MIA88LA263Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Lakeland, FLWhile on a ferry flt shortly after takeoff the plt reported that the eng slowly began to lose power. He then attempted to land on another rwy but lost control of the acft & crashed short. An eng run was accomplished which revealed no evidence of pre-impact…NTSB FTW88LA159Accident · No injuriesLimited investigationFinal reportCessna 180H · Welsh, LAThe pilot was landing the tailwheel type airplane on runway 6 while the winds were from 270 degrees at 15 knots, gusting to 25 knots. After touchdown, it ballooned several feet, touched on the left wheel, then the left wing tip and flipped forward to the…NTSB FTW88LA158Accident · Minor injuriesLimited investigationFinal reportBell 206B · West Cameron 28The pilot landed the heicopter on a drilling platform and instructed the mechanic to install only the forward tie-downs. The mechanic secured the forward and aft tie-downs and secured the forward rotor blades. When the pilot returned to the helicopter, he…NTSB FTW88DRG12Accident · No injuriesFinal reportCessna 182R · Spicewood, TXThe plt said the windsock indicated the wind was from the northeast; however, witnesses said the winds were from the south & the acft landed downwind. The plt said he went around after the 1st apch, & on the next pattern, he made a lowerfinal apch. He said…NTSB DEN88LA196Accident · No injuriesLimited investigationFinal reportCessna 182RG · Antelope Wells, NMThe commercial plt was flying three passengers to buy cattle. During takeoff from a 5,000 x 75 ft, wet gravel airstrip, the plt elected to use only the left side of the rwy to avoid mud. He used a soft field takeoff, with a nose high attitude, which limited…NTSB CHI88LA228Accident · Minor injuriesLimited investigationFinal reportLake LA-4-200 · Fox Lake, ILThe plt had just completed a course at the Lake acft factory school, but had not yet obtained a seaplane rating. After he flew home, he landed on local lakes. He reported that drg a landing on calm water, he expected to hear a 'slush sound' as the hull…NTSB LAX88LA304Accident · Serious injuriesLimited investigationFinal reportBell 206L-1 · Barrett Junct., CAWhile descending into a canyon, the aircraft struck powerlines, went into an uncontrolled descent and collided with the terrain. The pilot stated that he could not see the powerlines and that his visibility was restricted by the sun. All four passengers…NTSB FTW88DPJ11Accident · No injuriesFinal reportCessna 150F · Oklahoma City, OKThe student pilot had just returned to flying after an extended time. During the approach he failed to add carburetor heat and the engine failed when power was added. Automotive fuel was being used in the aircraft but the STC had not been complied with.NTSB DCA88MA072Accident · 14 fatalClass 1 · MajorFinal reportBoeing 727-232 · Dallas/Ft Worth, TX(1) The captain and first officer's inadequate cockpit discipline which resulted in the flightcrew's attempt to takeoff without the wing flaps and slats properly configured; and (2) the failure of the takeoff configuration warning system to alert the crew…NTSB BFO88LA081Accident · No injuriesLimited investigationFinal reportArthur Acrosport 1 · Danville, VAThe acft was on a performance test flight when a power loss occurred at 1100 ft MSL. The plt unsuccessfully tried to restart the engine and made a forced landing in an open field. Examination of the acft revealed the rubber hose vent line was obstructed with…NTSB BFO88LA080Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Charleston, WVThe plt was executing the ILS rwy 5 apch when he entered fog about 350 ft above the dh. According to the plt, upon reaching the dh he sighted the rwy and continued the apch. Afterward the plt said he deviated left of the localizer centerline and as he was…NTSB ATL88IA242Incident · No injuriesIncident investigationFinal reportBeech 23 · Frankfort, KYEngine quit during go-around from simulated engine failure. During completion of emergency procedure the fuel selector position was changed to opposite wing fuel tank. Later exam of the acft revealed that when the fuel selector valve handle indicated right…NTSB ANC88LA121Accident · No injuriesLimited investigationFinal reportMaule M-5-210C · Kukaklek, AKDuring the takeoff roll on the gravel bar the airplane crossed the gravel area on to the soft tundra. The pilot then lost directional control of the airplane. The airplane nosed over on its back.NTSB ANC88LA120Accident · No injuriesLimited investigationFinal reportCessna 170B · Willow, AKAfter the student did a touch and go, during the initial climb out, the airplane stalled and crashed into a row of trees at the end of the runway. The student pilot reportedly startled by turbulence, pulled rapidly back on the control yoke, and the aircraft…NTSB SEA88FA166Accident · 1 fatalField investigationFinal reportCessna 150H · Caldwell, IDThe plt flew to hubler field (a pvt 2800' strip) & landed. After landing on rwy 10, he taxied back to the apch end & took off again. As the acft was climbing, about 60' over trees at the departure end, it rolled abruptly to the left, entered a steep descent &…NTSB MKC88LA150Accident · No injuriesLimited investigationFinal reportAeronca 7CCM · Weiner, ARThe pilot handproped the starterless aircraft. After engine start, the pilot was unable to gain access to the cockpit, and the aircraft taxied uncontrolled into some nearby farm implements. The purpose of the flight was to ferry the acft for an annual…NTSB MIA88FA262Accident · 1 fatalField investigationFinal reportCommens Midget Mustang I · Davie, FLThe private pilot flying the homebuilt aircraft crashed into a swamp, and there were no witnesses. The aircraft was located 4 days later. Friends of the pilot recalled that in the 3 weeks prior to the accident the pilot had bragged to them about the high 'g'…NTSB LAX88DVA13Accident · No injuriesFinal reportAyres 600-S2D · Los Banos, CAPlt was engaged in aerial application when no 9 cyl head cracked. Plt returned for precautionary lndg. On approach, oil obscured windshield. Plt missed landing area; landed in cultivated field beside landing area. Acft nosed over.NTSB CHI88LA227Accident · No injuriesLimited investigationFinal reportCessna 172G · Sparta, MIDuring a takeoff attempt from his private strip the pilot elected to abort the takeoff. There was a slight quartering tailwind for the takeoff attempt. Due to the 'dense', damp grass, which was about 4 inches tall according to the pilot, braking effectiveness…NTSB CHI88FA226Accident · Serious injuriesField investigationFinal reportPiper PA-23-160 · Toledo, OHFatigue fracture, for reasons undetermined, which lead to the loss of a propeller blade from the right engine. This in turn lead to the marginal controllability of the aircraft.NTSB ATL88IA241Incident · Minor injuriesIncident investigationFinal reportBoeing 737-387 · Savannah, GAWhile cruising at FL 310, usair flight 333 encountered severe turbulence. The pilot reported observing the thunderstorm activity on the airborne radar. The flight was within 20 miles of the cell before action was taken to avoid the encounter. The recommended…NTSB ATL88DKG15Accident · Minor injuriesFinal reportRockwell S2R · Pelham, GAThe crop duster had completed the third swath run of the morning when the engine began to lose power. The plt released the contents of the hopper and made a forced landing in a soybean field. During the landing roll, the airplane nosed over and a ground fire…NTSB MKC88LA165Accident · No injuriesLimited investigationFinal reportCessna 182Q · St. Louis, MOThe plt said that during a night takeoff roll, he noticed an inoperative airspeed indicator, and elected to abort the takeoff. Unable to stop in the remaining distance, the acft ran off the end of the runway onto the grass overrun collapsing the nose wheel.…NTSB MKC88FA166Accident · Serious injuriesField investigationFinal reportCessna 150 · Reed Springs, MOThe accident aircraft was observed performing high speed passes at extremely low altitude over the lake. Witnesses estimated the altitude of the aircraft from 30 to 75 feet above the water. The aircraft struck 72,000 volt power lines at a point approximately…NTSB LAX88LA302Accident · Minor injuriesLimited investigationFinal reportBellanca 7ECA · Dunsmuir, CAJust after takeoff, the airplane gained just enough altitude to clear trees at the end of the runway. The pilot turned up a valley to gain altitude. The airplane was gaining altitude at 150 fpm, however, the valley turned into a box canyon and the airplane…NTSB LAX88LA301Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Goodyear, AZThe student pilot was on her second supervised solo flight. She had completed one touch and go landing and was attempting a second when the accident occurred. The pilot failed to flare the airplane at the proper time and the airplane collided with the terrain…NTSB LAX88DUQ05Accident · Serious injuriesFinal reportSchleicher ASW-20BL · Red Mountain, CANTSB FTW88LA157Accident · No injuriesLimited investigationFinal reportCessna 150M · Killeen, TXAccording to the pilot/operator aircraft accident report, the private pilot had not flown in the previous 90 days. The pilot was practicing landings on a dark night and collided with power lines 1000 feet short of the runway. After colliding with the wires,…NTSB DEN88LA195Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Rawlins, WYPlt and pax were on a flight from milwaukee, WI, to las vegas, NV. The plt made an unscheduled stop at Rawlins due to poor vis and low fuel. The airplane was loaded with suit cases, camping gear, coolers and full fuel. The pilot and pax combined weight was…NTSB DEN88LA192Accident · No injuriesLimited investigationFinal reportCessna 206 · Saint George, UTDrg the landing roll, the nose gear collapsed, then the acft veered off the rwy, enctrd soft dirt/gravel terrain & nosed over. A post-acdnt inspn revealed that two attaching bolts on the left side of the nose gear yoke had failed & that the TW0 bolts on the…NTSB ANC88LA118Accident · No injuriesLimited investigationFinal reportCessna 170B · Anchorage, AKThe plt was practicing touch-&-go landings. On the first landing, the acft bounced & a successful go-around was made. During the second landing, the plt lost directional control of the acft & it went off the left side of the rwy & was damaged.NTSB SEA88LA165Accident · No injuriesLimited investigationFinal reportLatham Alco Coupe · Bremerton, WAPlt had about 4 hrs exp in make and model and 116 hrs total pilot time. Flew 'about 2 hrs' on 15 gals fuel and was making touch and go lndgs when power was lost. Acft nosed over during forced lndg in soft terrain. There was no evidence of fuel on board.