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 MIA75DLD21Accident · No injuriesClosedBell 47G-5 · Plant City, FLSep 24, 1974 · N2214W · Substantial damage NTSB NYC75FGM04Accident · No injuriesClosedBell 47G-5 · Sligo, PAAug 1, 1974 · N6277N · Substantial damage NTSB LAX75FUQ05Accident · No injuriesClosedBell 47G-5 · Oceanside, CAJul 17, 1974 · N2252W · Substantial damage NTSB IAD75DKM03Accident · No injuriesClosedBell 47G-5 · Charlotte, NCJul 12, 1974 · N7089J · Substantial damage NTSB CHI75FEI01Accident · Minor injuriesClosedBell 47G-5 · Wauseon, OHJul 8, 1974 · N4041G · Substantial damage NTSB LAX74FVM28Accident · 1 fatalClosedBell 47G-5 · Cayucas, CAMay 23, 1974 · N1329X · Destroyed NTSB CHI74FEC36Accident · Minor injuriesClosedBell 47G5 · Flint, MIApr 12, 1974 · N8142J · Substantial damage NTSB LAX74DUJ49Accident · No injuriesClosedBell 47G-5 · Yuma, AZApr 6, 1974 · N2294W · Substantial damage NTSB OAK74DVD28Accident · No injuriesClosedBell 47G-5 · Stockton, CAMar 24, 1974 · N7923J · Substantial damage NTSB MIA74DLD71Accident · No injuriesClosedBell 47G5 · Arcadia, FLMar 9, 1974 · N8197J · Substantial damage NTSB IAD74FLJ28Accident · No injuriesClosedBell 47G-5 · Knightdale, NCJan 12, 1974 · N8563F · Substantial damage NTSB LAX74DUG31Accident · No injuriesClosedBell 47G-5 · La Verne, CANov 30, 1973 · N4741R · Substantial damage NTSB NYC74AN035Accident · 2 fatalClosedBell 47G-5 · Waynesburg, PAOct 25, 1973 · N8556F · Destroyed NTSB MKC74FCA12Accident · No injuriesClosedBell 47G-5 · Creve Coeur, MOOct 22, 1973 · N2251W · Substantial damage NTSB OAK74DVA22Accident · No injuriesClosedBell 47G-5 · Fresno, CAOct 4, 1973 · N1329X · Substantial damage NTSB CHI74FEG08Accident · No injuriesClosedBell 47-G5 · Washingtn Ch, OHSep 24, 1973 · N4101G · Substantial damage NTSB OAK74FVM08Accident · Minor injuriesClosedBell 47G-5 · Santa Clara, CAAug 31, 1973 · N4754R · Substantial damage NTSB IAD74FIG06Accident · Minor injuriesClosedBell 47G-5 · Berlin, MDAug 4, 1973 · N1468W · Substantial damage NTSB LAX74DUJ05Accident · No injuriesClosedBell 47G-5 · Yuma, AZJul 27, 1973 · N2294W · Substantial damage NTSB MKC74DER01Accident · No injuriesClosedBell 47G-5 · Bloomington, MNJul 20, 1973 · N4064G · Substantial damage NTSB DEN74FQA03Accident · No injuriesClosedBell 47G5 · Albuquerque, NMJul 8, 1973 · N6278N · Substantial damage NTSB MKC73FCA30Accident · Minor injuriesClosedBell 47G-5 · St Louis, MOJun 24, 1973 · N7043J · Destroyed NTSB CHI73DEP66Accident · Minor injuriesClosedBell 47G-5 · Appleton, WIJun 24, 1973 · N7840S · Substantial damage NTSB MIA73DLA46Accident · No injuriesClosedBell 47G-5 · Newberry, FLJun 18, 1973 · N2214W · Substantial damage NTSB IAD73FKM43Accident · Serious injuriesClosedBell 47G5 · Charlotte, NCJun 3, 1973 · N7089J · Substantial damage NTSB FTW73DPD41Accident · No injuriesClosedBell 47G-5 · Gainesville, TXMay 29, 1973 · N8563F · Substantial damage NTSB OAK73FJA12Accident · Serious injuriesClosedBell 47G-5 · Koloa, HIFeb 7, 1973 · N7060J · Substantial damage NTSB FTW73DRG47Accident · No injuriesClosedBell 47G-5 · Harlingen, TXFeb 2, 1973 · N7923J · Substantial damage NTSB MIA73DLD54Accident · No injuriesClosedBell 47G-5 · Avon Park, FLJan 27, 1973 · N1476W · Destroyed NTSB FTW73FPA20Accident · No injuriesClosedBell 47G-5 · Dallas, TXJan 10, 1973 · N1365X · Substantial damage NTSB MKC73DCA09Accident · Minor injuriesClosedBell 47G-5 · Chesterfield, MODec 13, 1972 · N7042J · Destroyed NTSB FTW73DRG30Accident · No injuriesClosedBell 47G-5 · Harlingen, TXDec 7, 1972 · N7923J · Substantial damage NTSB MKC73DCG06Accident · No injuriesClosedBell 47G-5 · Forsyth, MOSep 2, 1972 · N6203N · Substantial damage NTSB LAX73FUQ05Accident · No injuriesClosedBell 47G-5 · Oxnard, CAAug 16, 1972 · N7915S · Destroyed NTSB LAX73FUJ11Accident · No injuriesClosedBell 47-G5 · Chandler, AZAug 2, 1972 · N7808S · Substantial damage NTSB LAX73FUD02Accident · No injuriesClosedBell 47G-5 · Santa Mnica, CAJul 21, 1972 · N4798R · Substantial damage NTSB MKC73FER04Accident · Minor injuriesClosedEL Tomcat MK6B · Miesville, MNJul 5, 1972 · N7840S · Destroyed NTSB NYC72FHM56Accident · No injuriesClosedBell 47G-5 · Freehold, NJJun 5, 1972 · N4101G · Substantial damage NTSB CHI72FEC47Accident · No injuriesClosedBell 47G-5 · Detroit, MIMay 25, 1972 · N7979J · Substantial damage NTSB MKC72FTK27Accident · Minor injuriesClosedBell 47G-5 · Pierre, SDApr 6, 1972 · N7870S · Substantial damage NTSB CHI72FEC28Accident · No injuriesClosedBell 47-G5 · Detroit, MIFeb 24, 1972 · N7979J · Substantial damage NTSB LAX72FVA37Accident · Serious injuriesClosedBell 47G5 · Mcfarland, CADec 17, 1971 · N8557F · Destroyed NTSB LAX72FUQ44Accident · Minor injuriesClosedBell 47G5 · Glendale, CANov 12, 1971 · N4713R · 2 aircraft · Substantial damage NTSB MKC72DER18Accident · Minor injuriesClosedBell 47G-5 · Blomkist, MNAug 25, 1971 · N7840S · Destroyed NTSB MKC72FCD08Accident · No injuriesClosedBell 47-G5 · New Market, IAJul 20, 1971 · N4705R · Destroyed NTSB MKC71FCA27Accident · No injuriesClosedBell 47G5 · Creve Coeur, MOMar 20, 1971 · N7043J · Substantial damage NTSB OAK71AP032Accident · 1 fatalClosedBell 47G-5 · S.Francisco, CAFeb 11, 1971 · N2294W · Destroyed NTSB LAX71FUJ40Accident · Serious injuriesClosedBell 47G-5 · El Mirage, AZOct 24, 1970 · N1375X · Destroyed NTSB NYC71FHJ07Accident · No injuriesClosedBell 47-G5 · Wading River, NYSep 2, 1970 · N8593F · Substantial damage NTSB MIA71FLD10Accident · Minor injuriesClosedBell 47G-5 · Frostproof, FLAug 17, 1970 · N4096G · Destroyed