NTSB investigations
70 cases where the first occurrence was “Undetermined”.
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\" = 400) 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" = 400) 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 MIA87LA034Accident · No injuriesLimited investigationFinal reportCessna 152 · Lantana, FLThe pilot stated the aircraft performed sluggishly during takeoff and would not climb to clear trees at the departure end of the runway. The takeoff was aborted and the aircraft overran the runway encountering sand and nosing over. The pilot stated that…NTSB ANC87LA005Accident · Serious injuriesLimited investigationFinal reportTaylorcraft BC-12D · Chickaloon Flat, AKThe pilot-in-command refused to cooperate and would not submit an NTSB form 6120.1 nor would he discuss the accident except that he crashed upon landing. The plts med. Cert had expired.NTSB FTW86FA107Accident · 2 fatalField investigationFinal reportPiper PA-31-350 · Huffman, TXThe pilot was being vectored around thunderstorms in the area just prior to the accident. During the last radio contact the pilot was issued a vector to the destination airport. During this turn, for unknown reasons, the pilot lost control of the aircraft and…NTSB ANC86LA036Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Kotzebue, AKThe student pilot lost control of the aircraft on landing at a winter ice landing strip.NTSB CHI86FA033Accident · 3 fatalField investigationFinal reportPiper PA-28-161 · Duluth, MNThe pilot departed crystal lake for a flight to visit relatives for thanksgiving. He did not obtain a preflight weather briefing nor did he contact any ground facility during the flight. He was qualified to fly in VFR conditions only. The aircraft impacted…NTSB DEN86FTE02Accident · 1 fatalFinal reportBeech 58 · Elbert, COThe acft crashed in a open field & was not found for 4 days. The home built acft, maintained largely by the plt, had the engine destroyed so completely that no determination could be made as to power being developed at impact. The plt reportedly had been…NTSB CHI85FA351Accident · 1 fatalField investigationFinal reportCessna 404 · South Lyon, MIThe acft took off and climbed to 5000 ft uneventfully. It then dropped off radar and subsequently impacted the ground in a flat upright attitude. A post-crash fire consumed the majority of the airframe. Eng and prop teardowns indicated no abnormalities and…NTSB NYC85FA189Accident · 2 fatalField investigationFinal reportSmith, Ted Aerostar Aerostar 601 · Erie, PADuring a normal IFR cruise flight, the pilot of air Ohio flight 21, did not respond to ATC instructions. Air Ohio flight 21 continued for 40 minutes with no reply and without deviation in altitude or heading until the discrete target disappeared from radar…NTSB SEA85LYE01Accident · No injuriesFinal reportLuscombe 8A · Cheney, WAAcft was found abandoned after sustaining substantial damage in apparent lndg attempt in snow-covered marsh. Presumed pilot had expired student certificate and had registered acft to self under an alias. Circumstances of mishap unknown.NTSB FTW84LAMS5Accident · 1 fatalFinal reportCessna 152 · Missing AcftN93480 departed lafayette, la on a reported 2 hr sight-seeing flt over the gulf of Mexico & failed to return. There was no further contact with the plt & neither the plt nor the Acft have been found. The plt left a note suggesting possible suicide. Info…NTSB NYC84FHD06Accident · No injuriesFinal reportBell 206L-1 · Tuckerton, NJAccording to the plt at 8 to 10 ft in a hover the cyclic snapped rearward 3 to 4 in with a noise from the rear. The tailboom was found bent aprx 45 degrees down and 15 degrees right with no evidence of ground contact on the tail skid shoe. Metallurgical…NTSB CHI84FA255Accident · 1 fatalField investigationFinal reportRobert B. Boston Glasair RG · Columbus, OHThe plt was on the 2nd leg of a flt to ferry the home-built acft to the lancaster arpt for further testing. After takeoff, he requested clearance to stay in the area for a few minutes. ATC asked him if he had a problem & the plt responded 'no, I just want to…NTSB FTW84FA237Accident · 1 fatalField investigationFinal reportBeech G35 · Tulsa, OKA witness stated it appeared as though the plt was attempting to perform a precautionary landing on a highway. As the acft reached the highway, the witness heard the engine accelerate to 'full power' and saw the acft pull up. The acft contacted the top static…NTSB MIA84LA128Accident · 4 fatalLimited investigationFinal reportCessna 172 · Marathon, FLThe acft was missing after departing on a flt from maraton, FL to everglades city, FL. Sar personnel found the bodies of the plt & 3 pax, but the acft was not found. It was presumed to have been destroyed during a crash in the gulf of Mexico.NTSB MIA84LA089Accident · 2 fatalLimited investigationFinal reportCessna P-210N · Key West, FLDuring his wx briefing the plt was given the flight precautions & enroute forecast along his proposed route of flt. Enroute at 14,000 ft the plt advised ARTCC that the flt had encountered rime ice. The controller cleared the flt to descend to 12,000 ft & the…NTSB ANC83FA143Accident · Serious injuriesField investigationFinal reportPiper PA-18 · Hope, AKThe acft crashed under unknown circumstances. The wreckage was removed after an aerial survey & has not been located.NTSB ATL83LA078Accident · 1 fatalLimited investigationFinal reportPiper PA-28-180 · Daufuskie Islan, SCThe pilot's wife stated her husband had departed tampa, FL and could not recall if he had indicated a destination. She further stated her husband had a "charter". Investigation by law enforcement and drug enforcement personnel located cocaine in the aircraft…NTSB LAX82DAMS1Accident · 2 fatalFinal reportWing D-1 · Catalina Island, CAThe flt departed torrance at 1259 PDT & VFR conditions existed at the time. When the flt did not return a search was initiated. The search was terminated after 4 days. Friends & relatives speculated this may have been a dual instruction flt in preparation for…NTSB FTW82FRA21Accident · 1 fatalFinal reportPiper PA-32 · Houston, TXThe acft was found in a rice field on 6/5/82. Narcotics were found in the acft along with a large quantity of money on the pilot's body. The acft had N38312 painted on the side. The acft was stolen in atlanta, ga in October of 1981.NTSB ANC82FAG14Accident · 3 fatalFinal reportCessna 180 · Skwenta, AKThe aircraft departed finger lake at approximately 1000 ast for a short ice fishing trip to fish lakes. The aircraft never returned and a search was started. The wreckage was located near the kahiltna river about 5 miles from the intended destination on…