NTSB investigations: Bell 47G-2, MN
18 cases on aircraft the registry lists as Bell 47G-2. 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.
Cases per year
| 1964 | 1 |
|---|---|
| 1965 | 1 |
| 1966 | 1 |
| 1968 | 1 |
| 1969 | 2 |
| 1970 | 1 |
| 1971 | 1 |
| 1973 | 2 |
| 1974 | 1 |
| 1975 | 1 |
| 1979 | 1 |
| 1981 | 2 |
| 1984 | 1 |
| 1990 | 1 |
| 2001 | 1 |
Where
Open the mapLatest cases
Query with SQL
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\" = 'MN' 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 ('1181008'))
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" = 'MN' 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 ('1181008'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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 CHI01LA259Accident · No injuriesLimited investigationFinal reportBell 47G-2 · Blooming Prairi, MNThe reported loss of engine power for undetermined reasons during a the cruise portion of a CFR part 137 observation, and the pilot not following the height/velocity charts data.NTSB MKC90LA088Accident · Serious injuriesLimited investigationFinal reportBell 47 · Oakdale, MNA slipping rotor drive clutch assembly due to improper maintenance by company personnel. Contributing factors were static wires in the path.NTSB CHI84LA245Accident · Serious injuriesLimited investigationFinal reportBell 47-G2 · Nimrod, MNWhile landing in an area of tall grass a skid collided with a sand ridge causing a roll over.NTSB CHI82DER14Accident · No injuriesClosedBell 47G2 · Kerrick, MNNTSB CHI81DER47Accident · No injuriesClosedBell 47G-2 · Gully, MNNTSB MKC79DER70Accident · No injuriesClosedBell 47G-2 · St.Peter, MNNTSB MKC75DER73Accident · No injuriesClosedBell 47G2 · Rosemount, MNNTSB MKC75DER12Accident · No injuriesClosedBell 47G-2 · Meridan, MNNTSB MKC73DER66Accident · No injuriesClosedBell 47G-2 · Brainerd, MNNTSB MKC73AK059Accident · No injuriesClosedBell 47G-2 · Owatonna, MNNTSB MKC71DER74Accident · Minor injuriesClosedBell 47G2 · Franklin, MNNTSB MKC71DDM14Accident · No injuriesClosedBell 47G-2 · Morton, MNNTSB MKC70F0169Accident · Minor injuriesClosedBell 47G-2 · Lakeville, MNNTSB MKC69F0410Accident · Minor injuriesClosedBell 47G-2 · Red Wing, MNNTSB MKC69D0059Accident · No injuriesClosedBell 47G-2 · Guckeen, MNNTSB MKC67A0003Accident · 1 fatalClosedBell 47G-2 · St.Paul, MNNTSB MKC65A0072Accident · No injuriesClosedBell 47G2 · Brooklyn Prk, MNNTSB UNK64X2623Accident · Serious injuriesClosedBell 47G2 · Lake Lillian, MN