Skip to content

NTSB investigations · 379

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 ('1181008') 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 ('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_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 ('1181008')
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 ANC69D0040Accident · No injuriesClosedBell 47G-2 · Minchumina, AKJul 14, 1968 · N6711D · Substantial damage NTSB MIA69D0067Accident · No injuriesClosedBell 47G-2 · Panama City, FLJun 29, 1968 · N5185B · Substantial damage NTSB MKC69D0059Accident · No injuriesClosedBell 47G-2 · Guckeen, MNJun 23, 1968 · N4735S · Substantial damage NTSB SEA69D0014Accident · Minor injuriesClosedBell 47G-2 · Mineral, WAJun 5, 1968 · N2803B · Substantial damage NTSB ANC68A0050Accident · No injuriesClosedBell 47G-2 · Cape Yakatga, AKJun 1, 1968 · N6751D · Substantial damage NTSB UNK68X0141Accident · No injuriesClosedBell 47G-2 · Alberta, CanadaMay 24, 1968 · N6141 · Destroyed NTSB SEA68D0297Accident · No injuriesClosedBell 47G-2 · Mansfield, WAMay 10, 1968 · N6717D · Substantial damage NTSB SEA68D0296Accident · No injuriesClosedBell 47G-2 · Bridgeport, WAApr 24, 1968 · N6717D · Substantial damage NTSB FTW68A0083Accident · No injuriesClosedBell 47G-2A · Leeville, LAMar 30, 1968 · N74096 · Substantial damage NTSB LAX68A0091Accident · Minor injuriesClosedBell 47G-2 · Hntngtn Bch, CAMar 24, 1968 · N6720D · Substantial damage NTSB CHI68A0062Accident · Serious injuriesClosedBell 47G-2 · Delta, OHJan 16, 1968 · N6772D · Substantial damage NTSB LAX68A0059Accident · No injuriesClosedBell 47G-2 · Lahabra, CADec 2, 1967 · N321R · Substantial damage NTSB LAX68A0050Accident · No injuriesClosedBell 47G-2 · Huntington, CANov 16, 1967 · N2870B · Substantial damage NTSB MIA68A0040Accident · No injuriesClosedBell 47G · Davie, FLOct 25, 1967 · N17271 · Substantial damage NTSB FTW68A0028Accident · Serious injuriesClosedBell 47G-2 · Leeville, LASep 7, 1967 · N6700D · Destroyed NTSB LAX68A0024Accident · No injuriesClosedBell 47G-2 · Hntngtn Bch, CAAug 23, 1967 · N6720D · Substantial damage NTSB LAX68A0022Accident · Minor injuriesClosedBell 47G-2 · Camarillo, CAAug 18, 1967 · N5193B · Substantial damage NTSB ANC68A0004Accident · 1 fatalClosedBell 47G-2 · Cordova, AKJul 27, 1967 · N8406E · Destroyed NTSB DIA68A0003Accident · No injuriesClosedBell 47G-2 · Frisco, NCJul 26, 1967 · N6752D · Substantial damage NTSB ANC68A0002Accident · Serious injuriesClosedBell 47G-2 · Beaver, AKJul 11, 1967 · N499EA · Destroyed NTSB NYC67A0187Accident · No injuriesClosedBell 47G-2 · Bedford, PAJun 24, 1967 · N6749D · Substantial damage NTSB MKC67A0078Accident · Serious injuriesClosedBell 47G-2 · West Plains, MOJun 10, 1967 · N2813B · Destroyed NTSB ANC67A0061Accident · Minor injuriesClosedBell 47G-2 · Cold Bay, AKJun 8, 1967 · N6751D · Substantial damage NTSB SEA67A0071Accident · No injuriesClosedBell 47G-2 · Kennewick, WAJun 1, 1967 · N6145C · Substantial damage NTSB OAK67A0082Accident · No injuriesClosedBell 47G-2 · King City, CAMay 25, 1967 · N6728D · Substantial damage NTSB MIA67A0105Accident · Minor injuriesClosedBell 47G-2 · Foley, ALApr 8, 1967 · N6714D · Substantial damage NTSB SEA67A0057Accident · No injuriesClosedBell 47G-2 · Seattle, WAApr 3, 1967 · N8448E · Substantial damage NTSB MIA67A0086Accident · No injuriesClosedBell 47G-2 · Ft.Lauderdale, FLFeb 19, 1967 · N2487B · Substantial damage NTSB MIA67A0084Accident · No injuriesClosedBell 47G-2 · Donelson, TNFeb 14, 1967 · N6746D · Substantial damage NTSB ANC67A0037Accident · 1 fatalClosedBell 47G-2 · Anchorage, AKOct 16, 1966 · N2816B · Destroyed NTSB FTW67A0041Accident · No injuriesClosedBell 47G-2 · Prt Mansfield, TXOct 2, 1966 · N13658 · Substantial damage NTSB ANC67A0014Accident · No injuriesClosedBell 47G-2 · Tyonek, AKJul 24, 1966 · N6717D · Substantial damage NTSB ANC67A0012Accident · No injuriesClosedBell 47G-2 · Copper Cntr, AKJul 21, 1966 · N6141 · Substantial damage NTSB MKC67A0003Accident · 1 fatalClosedBell 47G-2 · St.Paul, MNJul 15, 1966 · N2820B · Destroyed NTSB ANC67A0003Accident · No injuriesClosedBell 47G-2 · Cordova, AKJul 7, 1966 · N8406E · Substantial damage NTSB OAK66A0059Accident · No injuriesClosedBell 47G2 · Calistoga, CAJun 24, 1966 · N2817B · Substantial damage NTSB LAX66A0100Accident · Minor injuriesClosedBell 47G-2 · Perris, CAJun 13, 1966 · N2876B · Substantial damage NTSB OAK66A0050Accident · No injuriesClosedBeel 47G-2 · Greenfield, CAMay 6, 1966 · N6728D · Substantial damage NTSB MIA66A0125Accident · Minor injuriesClosedBell 47G-2 · Homestead, FLApr 26, 1966 · N6774D · Substantial damage NTSB MIA66A0119Accident · Serious injuriesClosedBell 47G-2 · Lafollette, TNApr 10, 1966 · N5182B · Substantial damage NTSB NYC66A0111Accident · Serious injuriesClosedBell 47G-2 · Bayside, VAApr 4, 1966 · N6752D · Substantial damage NTSB MIA66A0091Accident · No injuriesClosedBell 47G-2 · Gold Hill, NCFeb 19, 1966 · N5194B · Substantial damage NTSB LAX66A0052Accident · Minor injuriesClosedBell 47G-2 · Piru, CADec 31, 1965 · N972B · Substantial damage NTSB SEA66A0032Accident · Minor injuriesClosedBell 47G-2 · 38mi E.Kelso, WANov 23, 1965 · N6145C · Substantial damage NTSB DEN66A0026Accident · No injuriesClosedBell 47G-2 · Queen Creek, AZOct 14, 1965 · N5158B · Substantial damage NTSB ANC66Z0015Accident · No injuriesClosedBell 47G-2 · 75e Umiat, AKOct 10, 1965 · N60H · Destroyed NTSB ANC66A0004Accident · No injuriesClosedBell 47G2 · Kakhonak, AKAug 17, 1965 · N977B · Substantial damage NTSB NYC66A0014Accident · No injuriesClosedBell 47G2 · Hollywood, MDJul 27, 1965 · N6752D · Substantial damage NTSB MKC66A0005Accident · No injuriesClosedBell 47G2 · Keystone, SDJul 22, 1965 · N262MV · Substantial damage NTSB MIA66A0003Accident · Minor injuriesClosedBell 47G-2 · Selma, ALJul 7, 1965 · N6714D · Substantial damage

Back to Bell 47G-2