NTSB investigations: Boeing B-17G

14 cases on aircraft the registry lists as Boeing B-17G. 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

19642026

NTSB investigations: Boeing B-17G per year, 1964–2026: 14 cases
1964	1
1966	1
1967	2
1971	1
1972	1
1973	1
1976	2
1987	1
1995	1
2011	1
2019	1
2022	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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1380204')) 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 ('1380204'))
  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 ('1380204'))
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 CEN23MA034Accident · 6 fatalClass 1 · MajorFinal reportBoeing B17 · Dallas, TXthe air boss’s and air show event organizer’s lack of an adequate, prebriefed aircraft separation plan for the air show performance, relying instead on the air boss’s real-time deconfliction directives and the see-and-avoid strategy for collision avoidance,…Nov 12, 2022 · N7227C · 2 aircraft · Destroyed NTSB ERA20MA001Accident · 7 fatalClass 2 · MajorFinal reportBoeing B17 · Windsor Locks, CTThe pilot’s failure to properly manage the airplane’s configuration and airspeed after he shut down the No. 4 engine following its partial loss of power during the initial climb. Contributing to the accident was the pilot/maintenance director’s inadequate…Oct 2, 2019 · N93012 · Destroyed NTSB CEN11FA383Accident · Minor injuriesField investigationFinal reportBoeing B-17G · Oswego, ILAn inadequate repair of the fuel tank that allowed the fuel leak to continue, ultimately resulting in an in-flight fire.Jun 13, 2011 · N390TH · Substantial damage NTSB MIA96LA017Accident · No injuriesLimited investigationFinal reportBoeing B-17G · Fayetteville, NCthe failure of the airplane's normal brake system due to the open position of the pressure relief valve. Contributing to the accident was the pilot in command's premature engine shutdown resulting in the airplane colliding with the localizer building.Nov 3, 1995 · N3703G · Substantial damage NTSB NYC87LA238Accident · Serious injuriesLimited investigationFinal reportBoeing B-17G · Beaver Falls, PADrg an apch in gusty winds, the plt noted a rgt x-wind. He stated that after touchdown, the roll-out was stabilized for a short distance, then the rgt wing began to lift. He applied full aileron & rudder to maint control, but was unable to stop on the…Aug 23, 1987 · N93012 · Substantial damage NTSB MIA76FKG96Accident · No injuriesClosedBoeing B-17G · Cordele, GAAug 17, 1976 · N3701G · Substantial damage NTSB MIA76FKG94Accident · Minor injuriesClosedBoeing B-17G · Rochelle, GAAug 5, 1976 · N4710C · Destroyed NTSB OAK74FXQ07Accident · 2 fatalClosedBoeing B-17G · Eureka, NVJul 12, 1973 · N620L · Destroyed NTSB DEN73FQA05Accident · 2 fatalClosedBoeing B-17 · Socorro, NMJul 12, 1972 · N73648 · Destroyed NTSB LAX72DUJ07Accident · No injuriesClosedBoeing B-17G · Tucson, AZJul 12, 1971 · N9324Z · Destroyed NTSB SEA68A0020Accident · Serious injuriesClosedBoeing B-17 · Kalispell, MTAug 29, 1967 · N7228C · Destroyed NTSB SEA68A0009Accident · No injuriesClosedBoeing B-17G · Carson, WAJul 27, 1967 · N5237V · Substantial damage NTSB DEN66A0062Accident · No injuriesClosedBoeing B-17G · Cody, WYMar 6, 1966 · N7228C · Substantial damage NTSB UNK64X0813Accident · Minor injuriesClosedBoeing B-17 · Santiago, DRMar 6, 1964 · N5225V · Destroyed