NTSB investigations
115 cases where the first occurrence was “Missing aircraft”.
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 c.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 420) 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."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 420) 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 CHI92FAMS2Accident · 4 fatalMissing aircraftFinal reportCessna 172N · Lake Michigan, MIUndetermined.NTSB ANC92FAMS2Accident · 5 fatalMissing aircraftFinal reportCessna 340 · Yakutat, AKMissing aircraft due to undetermined causes.NTSB MIA92FAMS1Accident · 1 fatalMissing aircraftFinal reportPiper PA-28-181 · MissingUndetermined.NTSB CHI92FAMS1Accident · 2 fatalMissing aircraftFinal reportBeech 95-BE55 · Benton Harbor, MIUndetermined.NTSB FTW92FAMS1Accident · 2 fatalMissing aircraftFinal reportGrumman F9F-8T · MissingUndetermined.NTSB LAX91LA365Accident · 2 fatalLimited investigationFinal reportPiper PA-38-112 · Oceano, CAUnknown. The main airplane wreckage and the body of the pilot are presumed lost at sea.NTSB MIA91FAMS1Accident · 1 fatalMissing aircraftFinal reportPiper PA-24-260 · Missing, FLUndetermined.NTSB ANC91GAMS1Accident · 3 fatalFinal reportGulfstream Aerospace 690C · Deadhorse, AKMissing aircraft.NTSB MIA90LA170Accident · 4 fatalLimited investigationFinal reportPiper PA-22-150 · Atlantic Ocean (Atlantic Ocean)Undetermined. The airplane is missing.NTSB MIA90LA139Accident · 1 fatalLimited investigationFinal reportPiper PA-28-140 · Caribbean SeaUndeterminedNTSB CHI90FAMS2Accident · 2 fatalMissing aircraftFinal reportPiper PA-30B · Charlevoix, MIThe probable cause of this accident is undetermined.NTSB MIA90LA061Accident · 2 fatalLimited investigationFinal reportCessna 152 · Missing, FLUndetermined.NTSB LAX90LAMS1Accident · 1 fatalFinal reportCessna U206E · Pacific Ocean (Pacific Ocean)Undetermined.NTSB SEA90FAMS1Accident · 1 fatalMissing aircraftFinal reportBeech 36TC · MissingUndetermined until the airplane is located.NTSB SEA89LA187Accident · 1 fatalClass 3 · LimitedFinal reportEvans Wittman Tailwind W10 · McCall, IDA collision with terrain for undetermined reasons.NTSB MIA89LAMS1Accident · 1 fatalFinal reportPiper PA-28-151 · Missing Acft (Atlantic Ocean)The pilot's decision to commit suicide. Contributing to the accident was the pilot's interpersonal relations and his psychological condition.NTSB DCA89LA012Accident · 1 fatalLimited investigationFinal reportMitsubishi MU-2J · Missing (Pacific Ocean)During a flt at night from majuro, marshall islands to cairns, australia, the plt requested a dscnt from FL 190 to 12,000 to remove ice from the airframe. Later, he requested a climb to FL 200. After starting the climb, he made a mayday call to sidney flt…NTSB ATL89FAMS2Accident · 1 fatalMissing aircraftFinal reportPiper PA-28-140 · MissingThe airplane and pilot reportedly departed moncks corner, SC sometime between 1900 and 2000 EDT on 4/17/88. The airplane was subsequently reported Missing, and search efforts were conducted between 4/20/88 and 4/29/88. Aircraft damage and injury index are…NTSB MIA88LA104Accident · 2 fatalLimited investigationFinal reportBeech 65-88Undetermined.NTSB CHI88FAMS1Accident · 4 fatalMissing aircraftFinal reportCessna 172N · Warsaw, INAircraft departed during the hours of darkness and was declared missing after failing to arrive at its stated destination. The proposed route of flight crossed a large body water and a local lakeshore resident reported hearing an airplane strike the water. No…NTSB MIA88LA073Accident · 1 fatalLimited investigationFinal reportCessna 152 · MissingAccording to the operator the acft departed san juan, PR on a cross country flight to la romana. The acft arrived there & dropped the student off & the plt departed at about 1400 ast on his return trip to san juan. The acft did not arrive at it's destination…NTSB LAX87FAMS4Accident · 1 fatalMissing aircraftFinal reportCessna 172P · Missing Acft, CAThe pilot told family and friends that he was going to fly along the coast and return at night. He did not return. The civil air patrol searched for the aircraft and pilot for several days without success. The flight originated at van nuys airport, van nuys,…NTSB MIA87LA164Accident · 1 fatalLimited investigationFinal reportCessna 402C · Missing Acft, BahamasOn 5/27/87 at about 0915 EDT, the plt departed palm beach intl arpt (pbi) on a flt to marsh harbour, great abaco island, Bahamas. When the Acft did not arrive at the destination, a search was initiated. The Acft was not fnd & was presumed to have been…NTSB LAX87FAMS2Accident · 2 fatalMissing aircraftFinal reportPiper PA-44-180T · Missing Acft (Pacific Ocean)The instructor plt (CFI) & the single-eng, pvt plt (owner) were on a flt to conduct multi-eng training for the new owner. Drg the flt, the crew contacted los angeles TRACON & requested a VOR apch to the santa monica arpt & said they would not be able to maint…NTSB NYC87FAMS1Accident · 1 fatalMissing aircraftFinal reportCessna 310 · Hamburg, NYThe Cessna 310R departed the airport on a svfr departure. The pilot cancelled his clearance a few minutes later and reported in VFR conditions. The aircraft failed to arrive at its destination. Radar tracking showed the aircraft heading toward lake erie. The…NTSB DEN86FAMS3Accident · 2 fatalMissing aircraftFinal reportMooney M20F · Cuba, NMThe acft departed a private airstrip in Cuba, NM, for the purpose of viewing real estate property before continuing to taos. State authorities were notified the following day when the plt failed to arrive at work. A search for the acft was conducted until…NTSB ANC86LA062Accident · 3 fatalLimited investigationFinal reportLake LA-4-200 · Lake Clark, AKThe aircraft crashed in Lake Clark, Alaska, and sank into 170 feet of water. There were no witnesses to the accident; the aircraft was not recovered.NTSB MIA86LA109Accident · 6 fatalLimited investigationFinal reportPiper PA-31-350 · Atlantic Ocean (Atlantic Ocean)The acft failed to arrive at it's destination on a VFR flight from miami FL, to west end, Bahamas. The acft's last reported position was 10 miles west of west end. There was no further contact with the acft. U.S. Coast guard initiated search on March 26, 1986…NTSB LAX86LAMS1Accident · 1 fatalFinal reportCessna U206C · Maunaloa, HIWhile on an inter-island cargo flight conducted under 14 CFR 135, the pilot reported to the honolulu ARTCC that the airplane was experiencing a loss of propeller RPM; he did not report that the engine was losing power. The airplane crashed into the pacific…NTSB ANC86FA032Accident · 1 fatalField investigationFinal reportCessna 206 · Anchorage, AKThe pilot was using the aircraft to commute on a weekly basis between his residence in Anchorage and to the king salmon area. The pilot received several preflight and inflight weather briefings. During the briefings the flight service station stated that VFR…NTSB LAX86FVM01Accident · No injuriesFinal reportPitts Special G-1 · Salinas, CAOn December 19, 1985, an experimental Pitts-special, N14JD, owned and operated by the owner crashed under unknown circumstances near Salinas, California. The pilot survived but the aircraft was not recovered. The pilot stated that he had an unknown flight…NTSB MIA86LA024Accident · 1 fatalLimited investigationFinal reportPiper PA-34-200T · Gulf Of MexicoAircraft disappeared from radar while operating in an area of level 3, 4, and 5 thunderstorms associated with tropical storm juan. A search by the u. s. coast guard resulted in no aircraft wreckage being found. The aircraft is missing and the pilot is…NTSB LAX86LA008Accident · 2 fatalLimited investigationFinal reportPiper PA-23-250 · Santa Barbara, CAOn oct. 3, 1985, pipter PA-23-250 crashed into the pacific ocean while on an air sampling flt near Santa Barbara, CA. The ac was destroyed and the two plts were fatally injured. The flt was to be flown along a predermined route utilizing loran navaids. The ac…NTSB FTW85LAMS2Accident · 1 fatalFinal reportSwearingen SA-226T · MissingA distress message was received from the pilot stating he was 100 miles south of grand isle, LA, and had lost an eng andwas unable to maintain altitude. A second message was received shortly afterwards stating that the aircraft was at 1500 feet and the pilot…NTSB NYC85FAMS1Accident · 2 fatalMissing aircraftFinal reportCessna 172N · Block Island, RIThe acft departed long Island on a VFR flt plan for Block Island. The plt did not close the flt plan after arrival at Block Island and departed Block Island without refiling a flt plan. The flt departed Block Island at night to the east over the ocean and has…NTSB MIA85LA249Accident · 2 fatalLimited investigationFinal reportPiper PA-28-160 · Key West, FLThe acft failed to arrive at its intended destination on a flt plan from ft. lauderdale FL. To Key West FL. Navy Key West apch was providing VFR flt following, radar & radiocontact was lost with the acft 20 NE of Key West. The whereabouts of the occupants are…NTSB CHI85FAMS3Accident · 1 fatalMissing aircraftFinal reportCessna 172The aircraft was seen to depart racine, WI on August 3, for ft meyers, FL, but never arrived at its destination. On the fourth day of the search a ramp check at albany-dougherty county airport, Georgia indicated that the aircraft was refueled there at approx…NTSB CHI85FAMS2Accident · 2 fatalMissing aircraftFinal reportCessna 170B · Chicago(L.Mich), ILAt an unknown time during the night of July 25/26 the acft crashed into lake Michigan. Exact wx conditions are unknown. The passenger was recovered from the lake the next morning, along with the two crushed front seats and two buckled interior side panels.…NTSB MIA85LA209Accident · 4 fatalLimited investigationFinal reportPiper PA-32R-301 · Bahamas, BahamasThe acft failed to arrive at it's intended destination on a flt from nassau, Bahamas to opa locka arpt, miami, FL. The acft was reported missing by the miami fss. The U.S. Coast guard initiated a search on 07-12-85 at about 1831 EDT & search was suspended on…NTSB CHI85FAMS1Accident · 1 fatalMissing aircraftFinal reportBeech E18S · Cleveland, OHThe flight departed & proceeded en route without incident. Radar & radio contact was maintained until the flt proceeded over lake erie. The flt did not arrive at it's destination. The acft is presumed to have crashed in lake erie. One identifiable 3 ft x 4 ft…NTSB MIA85LA176Accident · 1 fatalLimited investigationFinal reportCessna 210K · Missing AcftThe Acft departed miami, FL, at about 0700 EDT on a flt to port-au-prince, haiti. It did not arrive at its destination or return to miami. The Acft was not found & was presumed to have been destroyed. Also, the plt was not found & was presumed to have been…NTSB MIA85LAMS2Accident · 4 fatalFinal reportCessna 337 · Atlantic Ocean, FLThe acft was reported missing and search & rescue control center initiated a search on 1-17-85. The search was suspendedon 1-24-85. The last reported position of the acft was 66 miles northeast of jacksonville, FL. The acft is still missing & the damage index…NTSB MIA85LAMS1Accident · 1 fatalFinal reportAeronca 7ACAcft was reported overdue 3 days after it departed cross city, FL, on a VFR x-country. Search and rescue operations began on 12/26/84 and were suspended on 01/07/84. Plt and acft were not found.NTSB ATL85FAMS1Accident · 2 fatalMissing aircraftFinal reportGrumman American AA-5 · Dayton, OHAircraft missing on a flight from Dayton, OH to gallipolis, OH two persons on board.NTSB ANC84FAMS2Accident · 2 fatalMissing aircraftFinal reportPiper PA-12 · Anchorage, AKThe acft departed on 9-27-84 and was reported missing the following day. USAF rcc conducted 140 unsuccessful search missions. No wreckage was ever discovered. Both occupants are presumed to have been fatally injured.NTSB ANC84FAMS3Accident · 1 fatalMissing aircraftFinal reportCessna U206G · AKPlt received 2 wx briefings before the one hour fourty five minute flt. Plt was advised of adverse wx conditions in mountains with high winds and frequent low visibility. Icing conditions were also forecast btw 9,000 and 13,000 ft. the acft is still missing…NTSB ANC84LAMS1Accident · 5 fatalFinal reportCessna 401 · Anchorage, AKAt 0630 AKDT the plt obtained a wx briefing for the flt which forecast VFR with occasional marginal conditions along the route of flt. At 0704, the plt obtained an updated briefing at which time the destination of cantwell was reported IFR. At 0731 AKDT, the…NTSB NYC84FAMS1Accident · 2 fatalMissing aircraftFinal reportCessna 172N · Nantucket, MAThe acft disappeared after departing on the return leg of a x-country. The plt had called the operator at the home base and reported that IMC weather existed for the return. The plt was informed that the acft was not needed and he did not need to hurry back.…NTSB LAX84LAMS3Accident · 1 fatalFinal reportBellanca 17-31A · CABetween may 31 & June 1, 1984, the private plt is believed to have driven to the airport, parked his car, & boarded his aircraft for a presumed personal flt. The plt's wife became concerned about her husband's failure to appear at work, & she notified local…NTSB FTW84LAMS4Accident · 1 fatalFinal reportPiper PA-32-260 · Lafayette, LAThe acft has been missing since 5/10/84. The owner called for his acft preflighted and departed on a southerly heading. An off shore oil rig spotted a twin engine acft heading south. Search efforts by cap were unsuccessful. The plt gave no indication of his…