Skip to content

NTSB investigations · 20

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 ('1181024') 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 ('1181024')
  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 ('1181024')
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 NYC85LA081Accident · No injuriesLimited investigationFinal reportBell 47G-3 · Plainsboro, NJThe helicpopter crashed shortly after takeoff with 55 gallons of fertilizer on board. The plt stated that each time he made a swath run over the field the blades of the helicopter were picking up some of the liquid fertilizer. On takeoff helicopter felt…Jun 15, 1985 · N49882 · Substantial damage NTSB NYC84FGT02Accident · No injuriesFinal reportBell 47G-3 · Landisburg, PAThe helicopter lost eng power while turning on approach for landing, autorotated to a hard landing with main rotor contact to the tail boom. Two gals of fuel were drained from the acft fuel tank at the accident site. An eng run up was performed & found…Jun 4, 1984 · N49882 · Substantial damage NTSB MIA79ELA24Accident · Serious injuriesClosedBell 47G3 · Palatka, FLApr 24, 1979 · N49882 · Destroyed NTSB ANC76AA002Accident · No injuriesClosedBell 47G-3 · Nondalton, AKJun 28, 1975 · N8414E · Substantial damage NTSB CHI74FEA04Accident · Serious injuriesClosedBell 47G-3 · Dana, INJul 13, 1973 · N8416E · Substantial damage NTSB SEA73FTA07Accident · 1 fatalClosedBell 47G-3 · Moore, MTMay 19, 1973 · N8401E · Destroyed NTSB OAK72DVD03Accident · No injuriesClosedBell 47G3 · Tracy, CAJul 11, 1971 · N6787D · Substantial damage NTSB SEA70FDA06Accident · No injuriesClosedBell 47G3 · Jordan, MTMay 1, 1970 · N6787D · Substantial damage NTSB SEA70D0079Accident · No injuriesClosedBell 47G-3 · Circle, MTSep 12, 1969 · N6787D · Substantial damage NTSB DEN68A0035Accident · No injuriesClosedBell 47G-3 · Yellowstone P, WYFeb 3, 1968 · N8416E · Substantial damage NTSB SEA68A0006Accident · No injuriesClosedBell 47G-3 · Fairfield, MTJul 10, 1967 · N8414E · Substantial damage NTSB SEA67A0024Accident · No injuriesClosedBell 47G-3 · Challis, IDSep 17, 1966 · N8461E · Substantial damage NTSB SEA66A0053Accident · No injuriesClosedBell 47G-3B · Missoula, MTApr 30, 1966 · N8414E · Substantial damage NTSB OAK66A0046Accident · No injuriesClosedBell 47G-3 · Sierra City, CAMar 30, 1966 · N8437E · Substantial damage NTSB DEN66A0021Accident · Minor injuriesClosedBell 47G3 · South Fork, COSep 14, 1965 · N73913 · Substantial damage NTSB DEN66A0008Accident · No injuriesClosedBell 47G3B · Phoenix, AZJul 12, 1965 · N6788D · Substantial damage NTSB DEN65A0084Accident · No injuriesClosedBell B-47G3 · 10sw Payson, AZJun 25, 1965 · N6788D · Substantial damage NTSB ANC65A0047Accident · Serious injuriesClosedBell 47G3 · Anchorage, AKApr 27, 1965 · N8413E · Destroyed NTSB UNK65X0344Accident · No injuriesClosedBell 47G3 · Stevensville, MTOct 20, 1964 · N8418E · Destroyed NTSB UNK64X0604Accident · No injuriesClosedBell 47G-3 · Moab, UTFeb 18, 1964 · N8461E · Substantial damage

Back to Bell 47G-3