Skip to content

Major NTSB investigations

180,641 investigations by the National Transportation Safety Board since 1962: 174,620 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases, newest first

Query with SQL

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 (c.board_report_url IS NOT NULL OR c."investigationClass" = 'Class 1' OR c."caseType" = 'Major - Launch') ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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 (c.board_report_url IS NOT NULL OR c.\"investigationClass\" = 'Class 1' OR c.\"caseType\" = 'Major - Launch')
  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 (c.board_report_url IS NOT NULL OR c."investigationClass" = 'Class 1' OR c."caseType" = 'Major - Launch')
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 DCA83AA022Accident · 4 fatalFinal reportMitsubishi MU-2B-60 · Jeffersonville, GAThe acft was on the return portion of a round trip flt, hauling canceled bank checks. When they boarded before takeoff, the plt's wife, who was not a plt, occupied the r front seat & his 2 daughter's, ages 4 & 6, were in the passenger seats. Previous legs of…Mar 24, 1983 · N72B · Destroyed NTSB DCA83AA017Accident · Serious injuriesFinal reportde Havilland DHC-6-300 · Hailey, IDThe acft was less than 2 miles from the arpt of intended landing during the approach when the crew experienced a loss ofelevator control. The acft started diving toward the ground when the power was reduced. The plt applied full power to try and restore level…Feb 15, 1983 · N361V · Destroyed NTSB DCA83AA014Accident · 3 fatalFinal reportMcDonnell Douglas DC-8-54F · Detroit, MIAccording to witnesses, the takeoff roll was normal, & the acft rotated to a takeoff attitude about 1/2 to 2/3 of the way down the rwy. After lift-off, the acft's pitch attitude steepened & the plane climbed to about 1000 ft AGL. The acft then rolled to the…Jan 11, 1983 · N8053U · Destroyed NTSB DCA83AA013Accident · 1 fatalFinal reportConvair 580-11-A · Brainerd, MNDuring arrival, the acft was landed about 1725 ft beyond the rwy threshold. The touchdown was made with the right wing down & the right main gear about 37 ft from the right edge of the rwy. After touchdown, the acft continued to the right & the right…Jan 10, 1983 · N8444H · Substantial damage NTSB ATL83MA084Accident · 7 fatalClass 1 · MajorFinal reportBeech D55 · Cherry Point, NCThe two acft collided at about 9,500 ft MSL 30 mi south of Cherry Point. After departing nassau, the plt of the BE-D55 never activated his flt plan. An adiz penetration time was therefore never established. When the unidentified acft entered warning area…Jan 9, 1983 · N7142N · 2 aircraft · Destroyed NTSB DCA83AA010Accident · 2 fatalFinal reportCanadair CL-600-1A11 · Hailey, IDThe acft crashed into the side of a mountain ridge during a VFR attempt to land at an arpt with no instrument approach. The mountain ridge was obscured by broken clounds. The plt had cancelled his IFR clearance, & during the descent to the arpt, he had…Jan 3, 1983 · N805C · Destroyed NTSB DCA83AA006Accident · 3 fatalFinal reportCessna 182Q · Livingston, NJAero commander 560E, N3827C (27C), was returning from blairstown where it had been flown for minor maint. The plt was on an IFR flt plan, cleared by new york TRACON to proceed at 2000 ft MSL on a radar vector of 170 deg for an ILS apch to the teterboro arpt.…Nov 20, 1982 · N96402 · 2 aircraft · Destroyed NTSB DCA83AA005Accident · 3 fatalFinal reportCessna 551 · Mountain View, MOThe plt called from home at 0909 for an IFR clearance which became valid until 0930. He said he needed 15 min to get to the arpt. The call ended at 0914. The chief plt preflighted the acft while the plt was enroute to the arpt. The plt arrived between 0920 &…Nov 18, 1982 · N2CA · Destroyed NTSB LAX82AA274Accident · 3 fatalFinal reportBell UH-1B · Valencia, CAAcft being used to film movie scene depicting attack of village typical of villges in viet nam. Acft was about 25 ft AGL & above location where special effects explosives were detonated. As the plt turned acft for camera coverage, acft'stail section was…Jul 23, 1982 · N87701 · Substantial damage NTSB DCA82AA022Accident · Serious injuriesFinal reportde Havilland DHC-6-200 · Hooper Bay, AKAt 0833 adt, the acft departed bethel, AK on a scheduled pax/cargo commuter flt to chevak, scammon bay & Hooper Bay, AK. The operator's commuter flts had not landed at scammon bay for svrl days since the rwy was soft & muddy from meltingsnow. Bfr departing…May 16, 1982 · N103AQ · Destroyed NTSB DCA82AA020Accident · 4 fatalFinal reportGates Learjet 23 · Near Savannah, GAThe flt was cleared to descend from FL410 to FL390. The flightcrew acknowledged the clearance & ATC observed the radar target descend. The acft suddenly pitched up when within 600 ft of FL390 & climbed. The pitchup was followed by two pitch oscillations which…May 6, 1982 · N100TA · Destroyed NTSB DCA82AA016Accident · 1 fatalFinal reportde Havilland DHC-6 · Providence, RIAprx 15 min aft tkof, lgt icg was noted on the windshield. The aircrew activated the windshield washer/deice sys which used isopropyl alcohol. However, only a little deicing fluid was noted on either side. The sys was activated again. Aft hldg the sw svrl…Feb 21, 1982 · N127PM · Destroyed NTSB DCA82AA015Accident · Minor injuriesFinal reportNihon YS-11A · King Salmon, AKThe acft was on a scheduled flt from anchorage to cold bay, AK with intermediate stops at King Salmon & dutch harbor, AK. En route between anchorage & King Salmon, the air temps at cruise altitude were between -36 & -40 deg fahrenheit. While entering donwnd…Feb 16, 1982 · N169RV · Substantial damage NTSB DCA82AA009Accident · 2 fatalFinal reportPiper PA-31 · Ithaca, NYThe acft was on a scheduled commuter flt from utica, NY to Washington, DC with a stop at Ithaca, NY. The en route portion of the flt from utica to Ithaca was normal. At 0735 EST, the acft was at 6000 ft MSL when apch control informed the aircrew to expect an…Jan 5, 1982 · N546BA · Destroyed NTSB DCA82AA008Accident · 8 fatalFinal reportCessna 414A · Ashland, VAThe plt received 2 wx briefings, one on the evening bfr the flt, another at 1009 EST, within 3 hrs of the tkof time. IFR conditions were forcasted at the uncontrolled, destination arpt. The plt filed an IFR flt plan, but did not list an alternate arpt. The…Jan 3, 1982 · N2620L · Destroyed NTSB DCA82AA007Accident · 4 fatalClosedPiper PA-31 · Durango, CODec 31, 1981 · N41070 · Destroyed NTSB DCA82AA001Accident · 3 fatalClosedLearjet 24 · Felt, OKOct 1, 1981 · N44CJ · Destroyed NTSB DCA81AA028Accident · 2 fatalClosedPiper PA-34 · E.Rutherford, NJSep 23, 1981 · N8110R · 2 aircraft · Destroyed NTSB DCA81AA027Accident · No injuriesClosedLockheed L-1011 · Colts Neck, NJSep 22, 1981 · N309EA · Substantial damage NTSB DCA81AA026Accident · 1 fatalClosedDouglas DC-10 · N Atlantic Ocean (Atlantic Ocean)Sep 20, 1981 · N112WA · No damage NTSB DCA81AA017Accident · 3 fatalClosedExcalibur 65-A80 · Madisonville, TXJul 2, 1981 · N100UV · Destroyed NTSB DCA81AA015Accident · 15 fatalClosedHandly Page HP-137 · Loveland, COApr 17, 1981 · N11360 · 2 aircraft · Destroyed NTSB DCA81AA013Incident · No injuriesClosedBoeing 727 · Jamaica, NYApr 8, 1981 · N8140N · Minor damage NTSB DCA81AA008Incident · No injuriesClosedDouglas DC-10 · Leesburg, VAJan 31, 1981 · N143US · Minor damage NTSB DCA81AA007Accident · 5 fatalClosedCessna 500 · Bluefield, WVJan 21, 1981 · N501GP · Destroyed NTSB DCA81AA006Accident · 7 fatalClosedBeech 99A · Spokane, WAJan 20, 1981 · N390CA · Destroyed NTSB DCA81AA003Accident · Serious injuriesClosedBoeing 727 · Yap, MicronesiaNov 21, 1980 · N18479 · Destroyed NTSB DCA80AA022Accident · 3 fatalClosedPiper PA-31 · Philadelphia, PAJul 25, 1980 · N5MS · Destroyed NTSB DCA80AA020Accident · 3 fatalClosedLockheed 1049H · Columbus, INJun 22, 1980 · N74CA · Destroyed NTSB DCA80AA019Accident · 13 fatalClosedSwearingen 226TC · Valley, NEJun 12, 1980 · N650S · Destroyed NTSB DCA80AA017Accident · 2 fatalClosedLear Jet 23 · Richmond, VAMay 6, 1980 · N866JS · Destroyed NTSB LAX80FA092Accident · Serious injuriesClosedDouglas DC-9 · Edwards Afb, CAMay 2, 1980 · N980DC · Substantial damage NTSB FTW80AA057Accident · 7 fatalClosedPiper PA-31 · Houston, TXMar 21, 1980 · N59932 · Destroyed NTSB DEN80AA023Accident · 4 fatalClosedCessna TU206G · Clovis, NMFeb 6, 1980 · N7393N · 2 aircraft · Destroyed NTSB CHI80AA024Accident · 2 fatalClosedFalcon 10 · Chicago, ILJan 30, 1980 · N253K · Destroyed NTSB MIA80AA011Incident · No injuriesClosedDouglas DC-10 · Luxemburg, GeorgiaNov 11, 1979 · XA-DUH · Minor damage NTSB DCA80AA002Accident · 8 fatalClosedPiper PA-31 · Covington, KYOct 8, 1979 · N6642L · Destroyed NTSB DCA79AA020Accident · 8 fatalClosedDehavilland DH-114 · St Croix, VIJul 24, 1979 · N575PR · Destroyed NTSB DCA79AA019Accident · 1 fatalClosedDehavilland DHC-6 · Hyannis, MAJun 17, 1979 · N383EX · Destroyed NTSB DCA79AA017Accident · 271 fatalClosedDouglas DC-10 · Chicago, ILMay 25, 1979 · N110AA · Destroyed NTSB DCA79FA014Accident · 3 fatalClosedSikorsky S61-L · Newark, NJApr 18, 1979 · N618PA · Substantial damage NTSB DCA79AA016Accident · Minor injuriesClosedBoeing 727-31 · Saginaw, MIApr 4, 1979 · N840TW · Substantial damage NTSB DCA79AA012Accident · 3 fatalClosedNord-Avion 262 · Marina Del Rey, CAMar 10, 1979 · N418SA · Destroyed NTSB DCA79AA010Accident · Minor injuriesClosedDehavilland DHC-6 · Cheyenne, WYFeb 27, 1979 · N24RM · Substantial damage NTSB DCA79AA009Accident · No injuriesClosedBoeing 747 · Chicago, ILFeb 15, 1979 · N804FT · 2 aircraft · Substantial damage NTSB DCA79AA007Accident · 6 fatalClosedLear Jet 25D · Detroit, MIJan 19, 1979 · N137GL · Destroyed NTSB DCA79AA005Accident · 10 fatalClosedDouglas DC-8 · Portland, ORDec 28, 1978 · N8082U · Destroyed NTSB DCA79AA003Accident · 2 fatalClosedDehavilland DHC-6 · Steamboat Spgs, CODec 4, 1978 · N25RM · Destroyed NTSB DCA79AA002Accident · 5 fatalClosedLear Jet 25C · Anchorage, AKDec 4, 1978 · N77RS · Destroyed NTSB DCA78AA023Accident · 137 fatalClosedBoeing 727 · San Diego, CASep 25, 1978 · N533PS · 2 aircraft · Substantial damage