NTSB investigations: Bell 47G-5, MO

8 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 per year

19682026

NTSB investigations: Bell 47G-5, MO per year, 1968–2026: 8 cases
1968	1
1971	1
1972	2
1973	2
1976	1
1990	1

Where

Open the map

Latest cases

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."eventStateOrRegion" = 'MO' AND c."eventCountry" = 'USA' AND 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.\"eventStateOrRegion\" = 'MO' AND c.\"eventCountry\" = 'USA'
    AND 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."eventStateOrRegion" = 'MO' AND c."eventCountry" = 'USA'
  AND 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 MKC90LA124Accident · No injuriesLimited investigationFinal reportBell B47G-5 · Shell Knob, MOVisual outlook not maintained by the pilot in command.Jun 11, 1990 · N7089J · Substantial damage NTSB MKC76FCG98Accident · No injuriesClosedBell 47G-5 · King City, MOSep 22, 1976 · N8599F · Destroyed NTSB MKC74FCA12Accident · No injuriesClosedBell 47G-5 · Creve Coeur, MOOct 22, 1973 · N2251W · Substantial damage NTSB MKC73FCA30Accident · Minor injuriesClosedBell 47G-5 · St Louis, MOJun 24, 1973 · N7043J · Destroyed NTSB MKC73DCA09Accident · Minor injuriesClosedBell 47G-5 · Chesterfield, MODec 13, 1972 · N7042J · Destroyed NTSB MKC73DCG06Accident · No injuriesClosedBell 47G-5 · Forsyth, MOSep 2, 1972 · N6203N · Substantial damage NTSB MKC71FCA27Accident · No injuriesClosedBell 47G5 · Creve Coeur, MOMar 20, 1971 · N7043J · Substantial damage NTSB MKC69F0141Accident · Serious injuriesClosedBell 47G-5 · King City, MOJun 25, 1968 · N8599F · Destroyed