NTSB investigations · 58

Matched to the registry by N-number and event date, 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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = a.case_mkey WHERE a.aircraft_model_code IN ('1181410') 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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c.\"mKey\" = a.case_mkey
  WHERE a.aircraft_model_code IN ('1181410')
  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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = a.case_mkey
WHERE a.aircraft_model_code IN ('1181410')
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 DEN82DA147Accident · No injuriesFinal reportBell UH1B · Bryce Canyon, UTThe pilot was making an approach to a 10,000 ft mountain, let the RPM decay and made a hard landing. The density altitude was 12,500 feet. There was about 500 or 600 pounds of cargo on the long line.Jul 28, 1982 · N88389 · Substantial damage 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 LAX82DA264Accident · No injuriesFinal reportBell 204 · Delano, CAThe acft was spraying for mediterranean fruit flies with another acft. Entering a "scissors" or opposite direction pattern with the second helicopter spraying in the opposite direction, the plt had to slow down in order to begin his swath at the completion of…Jul 18, 1982 · N910PD · Destroyed NTSB LAX82FA061Accident · 1 fatalField investigationFinal reportBell UH1B · Lagunitas, CAHelicopter crashed into a reservoir and sank in 60 feet of water after tail boom separated during a log slinging operation. The pilot had lifted and began to back up when a loud noise was heard and the tail separated. The log was released and an auto-rotation…Jan 27, 1982 · N96142 · Destroyed NTSB DEN81FTI12Accident · No injuriesClosedBell UH1B · Heart Butte, MTJun 26, 1981 · N4237V · Substantial damage NTSB DEN81FA029Accident · 8 fatalClosedBell UH-1B · Williston, NDMay 1, 1981 · N46942 · Destroyed NTSB DEN80FA060Accident · 1 fatalClosedBell UH-1B · Provo, UTSep 2, 1980 · N99478 · Substantial damage NTSB DEN80FTA21Accident · No injuriesClosedBell UH-1B · Red Lodge, MTSep 1, 1980 · N911CD · Substantial damage

Back to Bell UH-1B