Skip to content

NTSB investigations: Bell 47G-5

184 cases on aircraft the registry lists as Bell 47G-5. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.

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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1181032')) 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1181032'))
  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 x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1181032'))
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 MKC71DCD13Accident · No injuriesClosedBell 47G-5 · Conrad, IAJul 21, 1970 · N8140J · Substantial damage NTSB LAX71DUM06Accident · No injuriesClosedBell 47G5 · Imperial, CAJul 19, 1970 · N7840S · Substantial damage NTSB LAX70FUM10Accident · No injuriesClosedBell 47G5 · Brawley, CAJun 8, 1970 · N6278N · Substantial damage NTSB CHI70DGJ13Accident · Minor injuriesClosedBell 47G-5 · Inez, KYApr 15, 1970 · N1470W · Substantial damage NTSB MIA70FLA11Accident · Minor injuriesClosedBell 47G-5 · Jasper, FLMar 23, 1970 · N7841S · Substantial damage NTSB FTW70FPD03Accident · No injuriesClosedBell 47G-5 · Saginaw, TXJan 16, 1970 · N2252W · Substantial damage NTSB NYC70D0002Accident · No injuriesClosedBell 47G-5 · Clarkstown, NYDec 1, 1969 · N8593F · Substantial damage NTSB MKC70D0204Accident · No injuriesClosedBell 47G-5 · Irwin, IAAug 26, 1969 · N7801S · Substantial damage NTSB MIA70F0184Accident · No injuriesClosedBell 47G-5 · Largo, FLJul 23, 1969 · N4041G · Destroyed NTSB NYC70D0055Accident · No injuriesClosedBell 47G-5 · Union City, PAJul 7, 1969 · N8556F · Substantial damage NTSB MIA70D0053Accident · Serious injuriesClosedBell 47G-5 · Hampton, TNJul 5, 1969 · N7841S · Destroyed NTSB NYC69D0277Accident · No injuriesClosedBell 47G-5 · Rochester, MANov 23, 1968 · N7815S · Substantial damage NTSB DIA69F0110Accident · Minor injuriesClosedBell 47G-5 · Roanoke, VANov 22, 1968 · N1201W · Substantial damage NTSB LAX69D0176Accident · Minor injuriesClosedBell 47G-5 · Cty Of Indusy, CANov 18, 1968 · N8586F · Substantial damage NTSB MKC69F0078Accident · No injuriesClosedBell 47G-5 · Glencoe, MNAug 26, 1968 · N7870S · Substantial damage NTSB OAK68A0075Accident · Minor injuriesClosedBell 47G-5 · Reno, NVJun 27, 1968 · N1393X · Substantial damage NTSB MKC69F0141Accident · Serious injuriesClosedBell 47G-5 · King City, MOJun 25, 1968 · N8599F · Destroyed NTSB DEN68D0026Accident · No injuriesClosedBell 47G-5 · Ogden, UTJun 14, 1968 · N7907S · Substantial damage NTSB DIA68D0204Accident · No injuriesClosedBell 47G5 · Asheville, NCMay 9, 1968 · N7841S · Substantial damage NTSB OAK68A0053Accident · Serious injuriesClosedBell 47G-5 · Minden, NVJan 24, 1968 · N1329X · Substantial damage NTSB OAK68A0025Accident · Minor injuriesClosedBell 47G-5 · Reno, NVSep 5, 1967 · N1364X · Substantial damage NTSB NYC68A0039Accident · Minor injuriesClosedBell 47G-5 · Westfield, MESep 1, 1967 · N7800S · Destroyed NTSB NYC68A0030Accident · 1 fatalClosedBell 47G-5 · Kingston, NHAug 22, 1967 · N8592F · Destroyed NTSB UNK67X0147Accident · No injuriesClosedBell 47G-5 · Iraklion, GreeceAug 18, 1967 · N1395X · Substantial damage NTSB LAX68A0003Accident · Minor injuriesClosedBell 47G-5 · Casa Grande, AZJul 10, 1967 · N1375X · Substantial damage NTSB FTW67A0107Accident · No injuriesClosedBell 47G-5 · Hallsville, TXMay 10, 1967 · N7815S · Substantial damage NTSB OAK67A0075Accident · No injuriesClosedBell 47G-5 · Gridley, CAMay 1, 1967 · N8594F · Substantial damage NTSB LAX67A0066Accident · Minor injuriesClosedBell 47G-5 · E.Los Angeles, CAJan 12, 1967 · N8586F · Substantial damage NTSB NYC67A0028Accident · Minor injuriesClosedBell 47G-5 · St.James, NYAug 17, 1966 · N8591F · Destroyed NTSB FTW67A0023Accident · No injuriesClosedBell 47G-5 · Wichita Falls, TXAug 11, 1966 · N1365X · Destroyed NTSB CHI67A0008Accident · Minor injuriesClosedBell 47G-5 · Plymouth, MIJul 21, 1966 · N1315X · Substantial damage NTSB UNK66X0156Accident · No injuriesClosedBell 47G-5 · Episkopi, GreeceJul 12, 1966 · N8574F · Destroyed NTSB NYC66A0131Accident · No injuriesClosedBell 47G-5 · Hickory, PAMay 13, 1966 · N8599F · Substantial damage NTSB MIA66A0122Accident · No injuriesClosedBell 47G-5 · Mcbee, SCApr 21, 1966 · N8556F · Substantial damage