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 NYC74FHJ31Accident · No injuriesClosedBell 47G-2 · Garden City, NYJun 11, 1974 · N6173 · Substantial damage NTSB SEA74DYG38Accident · Minor injuriesClosedBell 47G-2 · Ephrata, WAMay 4, 1974 · N7887B · Substantial damage NTSB IAD74FID36Accident · Minor injuriesClosedBell 47G-2 · Norfolk, VAMay 1, 1974 · N6752D · Destroyed NTSB ANC74AA069Accident · Minor injuriesClosedBell 47G-2 · Seward, AKApr 23, 1974 · N2822B · Substantial damage NTSB SEA74DYE42Accident · No injuriesClosedBell 47G-2 · Centralia, WAApr 18, 1974 · N984B · Substantial damage NTSB OAK74FVD22Accident · No injuriesClosedBell 47D1 · Sebastopol, CAMar 30, 1974 · N68367 · Substantial damage NTSB MIA74AM079Accident · Serious injuriesClosedBell 47G-2 · Miami, FLMar 14, 1974 · N4775S · Destroyed NTSB SEA74DYE39Accident · No injuriesClosedBell 47G-2 · Forks, WAMar 3, 1974 · N5161B · Substantial damage NTSB SEA74DYC25Accident · No injuriesClosedBell 47G-2 · Spokane, WAFeb 24, 1974 · N59H · Substantial damage NTSB LAX74AL057Accident · 2 fatalClosedBell 47D1 · Westminster, CAJan 28, 1974 · N74084 · Destroyed NTSB FTW74FQG36Accident · No injuriesClosedBell 47G-2 · Stratford, TXDec 30, 1973 · N6708D · Substantial damage NTSB MIA74ALD35Accident · Serious injuriesClosedBell 47G-2 · Ft Pierce, FLOct 28, 1973 · N2883B · Substantial damage NTSB OAK74DVD17Accident · No injuriesClosedBell 47G2 · Brentwood, CAOct 13, 1973 · N988B · Destroyed NTSB SEA74DYE20Accident · No injuriesClosedBell 47F-2 · Forks, WAOct 8, 1973 · N5161B · Substantial damage NTSB OAK74FVW08Accident · Minor injuriesClosedBell 47G2 · Arden, NVSep 22, 1973 · N2873B · Substantial damage NTSB FTW74FPG23Accident · Serious injuriesClosedBell 47G2 · Viola, ARSep 18, 1973 · N2870B · Substantial damage NTSB IAD74DKM17Accident · No injuriesClosedBell 47G-2 · Yadkinville, NCSep 1, 1973 · N262MV · Substantial damage NTSB MIA74D1011Accident · Minor injuriesClosedBell 47G-2 · Dalzell, SCAug 31, 1973 · N6711D · Substantial damage NTSB FTW74DRG16Accident · No injuriesClosedBell 47G-2 · Harlingen, TXAug 21, 1973 · N17121 · Substantial damage NTSB FTW74FPJ06Accident · 1 fatalClosedEL Tomcat MK5 · Springer, OKAug 16, 1973 · N11VH · Substantial damage NTSB MIA74FLA06Accident · No injuriesClosedBell 47G2 · High Springs, FLAug 4, 1973 · N5180B · Substantial damage NTSB OAK74FVM01Accident · Minor injuriesClosedBell 47G-2 · Salinas, CAJul 5, 1973 · N6728D · Substantial damage NTSB MIA73FKQ30Accident · No injuriesClosedBell 47G2-2 · Grenada, MSJun 25, 1973 · N4823 · Substantial damage NTSB OAK73DVA62Accident · No injuriesClosedBell 47G-2 · Kettlmn Cty, CAJun 9, 1973 · N6720D · Substantial damage NTSB MKC73DER66Accident · No injuriesClosedBell 47G-2 · Brainerd, MNJun 1, 1973 · N65520 · Substantial damage NTSB CHI73FEM61Accident · Minor injuriesClosedBell 47G2 · Marquette, MIMay 15, 1973 · N6725D · Substantial damage NTSB OAK73DVM32Accident · Serious injuriesClosedBell 47G-2A · King City, CAMay 10, 1973 · N2889B · Substantial damage NTSB MKC73AK059Accident · No injuriesClosedBell 47G-2 · Owatonna, MNApr 6, 1973 · N38926 · Substantial damage NTSB OAK73DVD28Accident · No injuriesClosedBell 47G-2 · Stockton, CAMar 18, 1973 · N5162B · Substantial damage NTSB OAK73DVM21Accident · No injuriesClosedBell 47G-2 · Salinas, CADec 15, 1972 · N6727D · Substantial damage NTSB LAX73DVA30Accident · No injuriesClosedBell 47G-2 · Richgrove, CANov 30, 1972 · N10194 · Substantial damage NTSB CHI73FEK10Accident · No injuriesClosedBell 47G-2 · Zanesville, OHNov 6, 1972 · N15952 · Destroyed NTSB LAX73DUQ04Accident · No injuriesClosedBell 47G-2 · Sylmar, CAAug 6, 1972 · N2879B · Substantial damage NTSB CHI73DEV05Accident · No injuriesClosedBell 47G-2 · Murdock, ILJul 23, 1972 · N12848 · Substantial damage NTSB MIA73FLG07Accident · No injuriesClosedBell 47G-2 · Pinewood, SCJul 22, 1972 · N6711D · Substantial damage NTSB ANC73AA006Accident · No injuriesClosedBell 47G-2 · Deadhorse, AKJul 18, 1972 · N959 · Substantial damage NTSB SEA73DYG02Accident · No injuriesClosedBell 47G-2 · Twisp, WAJul 7, 1972 · N6717D · Substantial damage NTSB OAK72DVD57Accident · No injuriesClosedBell 47G2 · Stockton, CAJun 9, 1972 · N5162B · Substantial damage NTSB SEA72DYG45Accident · No injuriesClosedBell 47G-2 · Warden, WAJun 4, 1972 · N1657 · Substantial damage NTSB LAX72FUG73Accident · No injuriesClosedBell 47G-2 · Glen Ivy, CAApr 24, 1972 · N6709D · Substantial damage NTSB FTW72DPM26Accident · No injuriesClosedBell 47G · Wynona, OKApr 5, 1972 · N993B · Substantial damage NTSB MKC72FCD63Accident · Minor injuriesClosedBell 47G-2 · Fremont, IAMar 20, 1972 · N976B · Substantial damage NTSB LAX72FUM17Accident · No injuriesClosedBell 47G-2 · Chula Vista, CAJan 1, 1972 · N919SF · Substantial damage NTSB LAX72FUG39Accident · No injuriesClosedBell 47B · La Verne, CADec 15, 1971 · N514SF · Substantial damage NTSB SEA72DYE16Accident · No injuriesClosedBell 47G2 · Clallam Bay, WAOct 6, 1971 · N5160B · Substantial damage NTSB CHI72FEM23Accident · No injuriesClosedBell 47G2 · Manistee, MISep 4, 1971 · N10NR · Destroyed NTSB CHI72FET06Accident · Minor injuriesClosedBell 47G-2 · Laporte, INAug 18, 1971 · N2495B · Destroyed NTSB MKC72FTG05Accident · Minor injuriesClosedBell 47G-2 · Ellendale, NDJul 11, 1971 · N4735S · Substantial damage NTSB NYC71IN121Incident · No injuriesClosedBell 47G-2 · Greenville, MEJun 17, 1971 · N2805B · Minor damage NTSB MKC71DER74Accident · Minor injuriesClosedBell 47G2 · Franklin, MNJun 15, 1971 · N13298 · Substantial damage

Back to Bell 47G-2