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 ATL84IA065Incident · No injuriesIncident investigationFinal reportSabreliner NA-265-80 · Cherry Point, NCThe pilot's inadequate preflight planning/preparation. Factors contributing to the accident were fog, rain, and lightning.NTSB NYC84FA054Accident · 1 fatalField investigationFinal reportCessna 310R · Buffalo, NYThe acft collided with lake erie during ILS approach to rwy 05 at Buffalo, NY. The acft had been descended to 3000 ft and the plt reported turning inbound from dunkirk VOR to the ILS. He was cleared for the approach and told to report the outer marker to…NTSB MIA84IA045Incident · Minor injuriesIncident investigationFinal reportDouglas DC-10-10 · West Palm Beach, FLThe acft experienced a failure of the right main landing gear truck while taxiing for takeoff. Metallurgical examinationrevealed stress corrosion which originated adjacent to the forward outboard longitudinal beam lubrication on hole.NTSB FTW84LA096Accident · Minor injuriesLimited investigationFinal reportCessna T210N · Port Arthur, TXThe acft crash landed in a muddy field about 1 mile from the arpt after the engine quit on final approach to land. The acft was examined after the accident and found to have an empty left fuel tank. The right tank contained 16 gallons of fuel. The plt stated…NTSB DEN84FA225Accident · 3 fatalField investigationFinal reportPiper PA-32 · Alma, COThe plt, his brother & his sister-in-law were on a flt to attend his mother's funeral. Before taking off, the pilot received a wx briefing & was advised that VFR flt was not recommended. The plt then asked for wx reports for a southerly route & he was advised…NTSB CHI84IA060Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-8-61 · Chicago, ILA DC-8-61 operated by capitol air inc experienced a partial failure of the left main gear on the landing roll. The rear portion of the left main landing gear bogie & both rear tires were separated. Components of the left landing gear were submitted to…NTSB NYC84FA053Accident · 2 fatalField investigationFinal reportCessna R182 · Greenwich, CTThe acft collided with trees during an ILS approach to westchester arpt in NY. The weather was IMC and an IFR flt plan was filed. The accident occurred during the 2nd attempt with the 1st ending in a missed approach. It was apparent to thecontroller that the…NTSB LAX84LA426Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · San Carlos, AZDuring a night landing on a road, the acft was damaged when it hit a berm. According to customs officials. The plt had circled while ground personnel placed rows of lights adjacent to the road, then he landed. There was evidence that illegal drugs had been…NTSB LAX84LA105Accident · Minor injuriesLimited investigationFinal reportBell 206B · Supai, AZThe plt was transporting an external load of drywall panels when the acft's eng chip light illuminated. He set the load down & inspected the acft & eng. Finding nothing wrong, he reconnected the cable which was connected to the net containing the panels.…NTSB LAX84LA104Accident · Serious injuriesLimited investigationFinal reportBell 47H-1 · Paradise, CAAccording to witnesses, the helicopter lifted off near the north end of rwy 17 while on an eastenly heading. After lift-off, it turned right, as if to proceed down the rwy. After rising to about 5 ft AGL, it settled & contacted the rwy, rose again, then…NTSB FTW84LA097Accident · No injuriesLimited investigationFinal reportBeech A-36 · Harrison, ARThe acft entered an area of icing and did not notify the ATC center of the icing problem. Although an emergency was not declared the plt did say he could not climb to an assigned alt after descending to try and lose ice accumulation. During the landing the…NTSB CHI84LA059Accident · Minor injuriesLimited investigationFinal reportCessna 310 · Brainerd, MNAfter making a vor/dme apch, the plt circled to land on rwy 23 in wx conditions of light snow & fog. The terrain & rwy were covered with snow. The plt tried to contact Brainerd UNICOM to have the rwy lights turned up, but he received no response. He could…NTSB ATL84FA064Accident · 1 fatalField investigationFinal reportPiper PA-24-260B · Mcdonald, TNThe plt received 2 wx briefings before takeoff & was provided flt precautions of IMC to continue beyond 0900 EST. Also, he was advised that the mountains would be occasionally obscured & icing could be expected to the west below 6000 ft. during both…NTSB ANC84LA024Accident · Minor injuriesLimited investigationFinal reportCessna 402A · Kotlik, AKDuring arrival, the plt landed on the frozen river, which was being used in lieu of the Kotlik airstrip. The landing area on the river was aprx 5000 ft long. After touchdown during the landing, some small children had run onto the departure end of the landing…NTSB NYC84FA052Accident · 1 fatalField investigationFinal reportCessna 425 · Newburgh, NYDuring arrival, there were indefinite delays at white plains, NY, so the plt diverted to Newburgh, NY. He was vectored for an ILS rwy 9 apch. While en route, the plt requested & was given the ILS freq, mins for the apch, the arpt elevation(491 ft MSL), the…NTSB NYC84FA047Accident · No injuriesField investigationFinal reportNorth American NA-265-40 · Coatesville, PADuring an IFR arrival, an ILS apch was made to rwy 29 in rain, turbulence & gusty wings. At aprx 400 ft AGL, the acft broke out of the clouds while on the localizer glide slope. The airspeed at that time was 8 KTS above the reference speed, but was…NTSB MKC84FA036Accident · No injuriesField investigationFinal reportBeech A36 · Kansas City, MOThe BE-A36 was holding short of rwy 18. The C-310 was taxiing to also hold short & collided with the BE-A36. The position & strobe lights on the BE-A36 were illuminated. The plt of the C-310 indicated that he did not see the BE-A36 because of what he…NTSB MIA84FA044Accident · 1 fatalField investigationFinal reportCessna 152 · Venice, FLThis was the first flt for the prospective student plt. He stated that during the second trafic pattern over the gulf, the acft appeared to hit a gust of wind, pitched up, & entered a spin. Winds were gusting 27 KTS, & severe wx was forecast & arrived later…NTSB FTW84LA095Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Gallup, NMThe plt reported that he was taking off from a dirt road when the eng lost power shortly after lift-off. Subsequently, the left main gear collapsed during a hard/forced landing.NTSB CHI84LA056Accident · No injuriesLimited investigationFinal reportCessna A185F · Bad Axe, MIDuring arrival, the plt was advised by the UNICOM operator that rwy 21 was the active rwy. Soon after landing, a passenger boarded the acft & the plt took off again. He proceeded to make a pattern around the arpt & initiated another landing on rwy 21. The…NTSB ATL84MA063Accident · 4 fatalMajor investigationFinal reportPiper PA-34-200T · Lawrenceburg, TNDuring the descent at Lawrenceburg the acft went into clouds at 3500 ft. at 1709 the acft was cleared for an NDB approach. Minimum alt for the approach is 1560 ft. field elevation is 936 ft. the acft was being tracked on radar and the last contact was about…NTSB ANC84LA023Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301 · Barrow, AKThe plt stated that shortly after reaching cruise altitude the eng failed. A forced landing was made on tundra covered by encrusted snow & ice nad the gear collapsed. During the on-scene investigation the fuel injector was found to allow only a small amount…NTSB MIA84FA043Accident · Serious injuriesField investigationFinal reportTemco Raley D-16A · Everglades City, FLPower was lost on both engs shortly after takeoff. The plt attempted to turn towards the shoreline & land in an open field but was unable to do so. The acft collided with the water while in a left bank & cartwheeled. The fuel line between the main fuel tank…NTSB LAX84FA101Accident · 2 fatalField investigationFinal reportBeech 95-A55 · Tucson, AZThe acft crashed during a local multi-engine instructional flight. There were no known witnesses to the accident. Examination of the wreckage failed to reveal any pre-impact malfunction of the aircraft or engine.NTSB FTW84LA093Accident · No injuriesLimited investigationFinal reportVickers Type 668 Varsity · El Paso, TXThe acft was on a flt from the El Paso intl arpt to the west Texas arpt. A hard landing was made causing all three landing gear to collapse, folded the left wing aft just inboard of the eng & twisted the entire right wing about 30 deg leading edge down.…NTSB ANC84LA022Accident · No injuriesLimited investigationFinal reportCessna C-185A · Quinhagak, AKThe acft struck a snowbank during an attemped go-around. According to the plt there were no mechanical problems that contributed to the accident. The plt did not submit an accident report and attempts to reach him by telephone have been unsuccessful. The…NTSB NYC84LA051Accident · No injuriesLimited investigationFinal reportCessna C172N · Meriden, CTThe acft collided with a dirt pile and nosed over during landing. According to the plt, he landed too FAR down the rwy, attempting an abort and the acft flipped over.NTSB NYC84LA050Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC Citabria · Nantucket, MAThe acft experienced a power loss and crashed during a low pass to observe an object on the ground. The flt had departednantucket and flown over to tuckernuck isl where a descent was made to observe an unusual object on a shoal. Carburetor heat was applied…NTSB NYC84FHM03Accident · No injuriesFinal reportHomebuilt Spad Xiii · Montgomery, NYThe acft lost power about 1 mile from the arpt and the plt made a forced landing on a farm. The acft nosed over. The weather conditions were conducive to carburetor icing and this acft has no provision for carburetor heat control.NTSB MIA84FA042Accident · 2 fatalField investigationFinal reportPiper PA-22 · Port Richie, FLThe acft crashed into trees during a night forced landing after the engine quit. The surviving passenger said he had metthe two plts in a bar where they drank beer. They later went to the arpt and flew x-country about 70 miles to eat & have more beer. They…NTSB LAX84LA100Accident · No injuriesLimited investigationFinal reportCessna A 188 A · Cantua Creek, CAThe acft collided with a pick-up truck during a landing on a private airstrip. The truck driver became distracted while driving alongside the dirt rwy and reported that he did not see the arriving acft.NTSB FTW84LA092Accident · Minor injuriesLimited investigationFinal reportCessna 175 · Washington, OKAbout 15 min after tkof the plt became aware that the ground below was covered with fog. The plt found a hold in the obscured ceiling, descended and established visual contact with a field. After circling the plt landed in the field. About halfway down the…NTSB FTW84LA091Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Winslow, ARDuring a wx briefing before takeoff, the plt was advised that VFR flt was not recommended. About 12 to 15 min after takeoff, he was forced to descend to maintain visual contact. He deviated south to avoid a rain shower. Subsequently, the plt realized he had…NTSB FTW84LA090Accident · No injuriesLimited investigationFinal reportBell 222U · Albuquerque, NMThe helicopter was parked on the ramp, facing east. When the plt called the tower for clearance, he requested a west departure. The plt received a clearance & was advised of traffic on the west ramp (behind the helicopter) & was instructed not to overfly the…NTSB CHI84LA057Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Owosso, MIThe acft crashed shortly after takeoff from owasso airport. The plt stated that he noticed the takeoff roll was longer than normal but everything seemed alright until approximately 100 ft AGL when the acft would no longer climb. The acft impacted about 1/2…NTSB CHI84FA058Accident · 4 fatalField investigationFinal reportCessna 207 · Put-In-Bay, OHThe plt & 3 passengers took off at night on an over water flt to an island in lake erie to provide help to a heart patient. No flt plan was filed & no record of a wx briefing was found. Reportedly, after takeoff, the acft disappeared in a cloud or haze. Also…NTSB LAX84LA099Accident · No injuriesLimited investigationFinal reportBeech 58TC · Santa Rosa, CAAfter making an ILS localtizer-only apch in heavy rain, the plt landed the acft long. When the acft touched down, the plt thought there was sufficient rwy remaining. However, he reported that he encountered hydroplaning conditions & was unable to stop on the…NTSB DEN84IA041Incident · No injuriesIncident investigationFinal reportBoeing 767 · Denver, COOn takeoff roll the no 3 wheel on the right main landing gear fell off the acft. The acft returned and landed without further incident. The wheel bearing was found faileddue to cosmoline contamination.NTSB SEA84FA101Accident · 1 fatalField investigationFinal reportCessna T210M · East Sound, WAThe acft collided with steeply upsloping terrain along the NE side of orcas island. The plt had been reportedly flying throughout the puget Sound/pacific nw area for more than 10 years & was familiar with the terrain & associated wx. Several plts located in…NTSB NYC84LA049Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Prospectville, PAThe plt stated that he inadvertently flared too high during his landing on rwy 32. The stall warning horn sounded and the left wing stalled. He said he added power but the aircraft did not respond to flt controls and flew left into trees.NTSB NYC84IA048Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-10-10 · Newark, NJThe acft experienced a complete truck beam failure after touchdown. Metallurgical examination revealed a crack near the right rear truck pivot pin lubrication hole which showed propagation to the lower end of the grease hole on the mating surface. Grease hole…NTSB LAX84LA102Accident · No injuriesLimited investigationFinal reportBeech V35B · St. Johns, AZAbout 10 min after takeoff the pax door opened & the plt elected to make a precautionary landing at St. Johns. Unaware that the wind was calm, the plt selected rwy 20, which is 3400 ft long, rather than RWY31, which is 5300 ft long, because when he departed…NTSB LAX84FA097Accident · Serious injuriesField investigationFinal reportBell 206B III · Grand Canyon, AZThe helicopter struck a cable while flying about 25 ft AGL in the Grand Canyon. The acft was on an aerial observation to survey and acquaint a passenger with the Arizona strip wilderness district. Phoenix fss highly recommends that plts not fly down into the…NTSB LAX84FA096Accident · 1 fatalField investigationFinal reportPiper PA-28-161 · Danville, CAThe acft collided with rising terrain at the 1600 ft level on a dark night. The plt was on a night cross-country and hadmade a radio call saying he was unsure of his position. He then reported his alt as 2000 ft. the buchanan tower gave him a heading to fly…NTSB CHI84LA055Accident · Minor injuriesLimited investigationFinal reportCessna 310L · West Lafayette, INThe plt was unable to start the eng with the batteries & made a start by using an APU. About 10 min after taking off, he noticed an off flag on the HSI. A further check was made & he discovered the left alternator was not functioning. He then checked the…NTSB LAX84LA111Accident · No injuriesLimited investigationFinal reportCessna 172G · Macdoel, CAThe acft collided with trees during landing rollout. The plt said he thought the wind was 'southerly at about 20 kts'. He stated that while flaring for landing on rwy 15 a stront gust estimated at 40 KTS was encountered & the acft drifted off the 40 ft wide…NTSB LAX84FA095Accident · 3 fatalField investigationFinal reportAerospatiale AS 355F · Black Mountain, NVThe helicopter tookoff on an air ambulance flt at about 1219 PST. According to tower personnel, the departure appeared normal. Radar service was terminated at 1227 & there was no further radio contact with the helicopter. Later, the helicopter was found where…NTSB MKC84LA035Accident · No injuriesLimited investigationFinal reportRockwell 114 · Council Bluffs, IAAccording to the plt, he landed on rwy 13, which was icy, and encountered a right x-wind. Subsequently, the acft drifted to the left, the left main gear hit a snowbank & the acft ground looped. The plt reported that the right wing hit snow & was damaged. He…NTSB MKC84FA034Accident · Serious injuriesField investigationFinal reportCessna 21ON · Wentzville, MOThe acft was landed with the landing gear partially extended during a forced landing after an engine failure. The plt delayed the extension of the gear because of the condition of the landing area. Examination of the engine showed a failure of the #2…NTSB FTW84LA089Accident · 1 fatalLimited investigationFinal reportCessna 150G · Clinton, OKThree witnesses observed the acft flying low before it went out of sight behind trees. Two of them reported that the plt made 3 low fly-bys with the eng sounding normal, then they heard the acft impact in a field on the 3rd pass. An exam of the crash site…