Fatal NTSB investigations: Republic RC-3
13 cases on aircraft the registry lists as Republic RC-3. 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
| 1966 | 1 |
|---|---|
| 1967 | 3 |
| 1968 | 1 |
| 1972 | 1 |
| 1975 | 1 |
| 1977 | 1 |
| 1985 | 1 |
| 1996 | 1 |
| 1999 | 1 |
| 2012 | 1 |
| 2016 | 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.\"highestInjuryLevel\" = 'Fatal'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('3080202'))
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."highestInjuryLevel" = 'Fatal'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('3080202'))
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 ERA16LA266Accident · 1 fatalLimited investigationFinal reportRepublic RC 3 · Winter Haven, FLImproper installation of a fuel line by unknown personnel, which resulted in a total loss of engine power during initial climb due to fuel starvation.NTSB ERA12LA562Accident · 1 fatalLimited investigationFinal reportRepublic RC-3 · Cedar Bluff, ALThe pilot's failure to see and avoid power lines during final approach to landing.NTSB SEA99FA146Accident · 2 fatalField investigationFinal reportRepublic RC-3 · Chimacum, WAThe inadequate visual lookout by both the pilot-in-command and second pilot, and the pilot-in-command's failure to maintain sufficient flying speed to prevent a stall condition. Contributing factors were the transmission lines, gusty wind conditions, and the…NTSB ANC96FA079Accident · 2 fatalField investigationFinal reportRepublic RC-3 Seabee · Ketchikan, AKthe airplane crashed for undetermined reason(s).NTSB CHI85FA234Accident · 1 fatalField investigationFinal reportRepublic RC-3 · Eveleth, MNOn takeoff from ely lake the acft turned sharp left at an altitude of 80-100 ft. at this point the acft ceased rated to climb and decended into trees and a lakeside house. The a cft was in excess of 400 lbs over gross weight. The lading gear and nose ballast…NTSB OAK77FA058Accident · 2 fatalClosedRepublic RC-3 · No.Las Vegas, NVNTSB IAD76AI034Accident · 1 fatalClosedRepublic RC-3 · Gastonia, NCNTSB CHI72FEI46Accident · 1 fatalClosedRepublic RC-3 · Cleveland, OHNTSB CHI69A0043Accident · 2 fatalClosedRepublic RC-3 · Lake Erie, OHNTSB NYC68A0061Accident · 1 fatalClosedRepublic RC-3 · Ashland, MENTSB UNK67X0158Accident · 1 fatalClosedRepublic RC-3 · Mcneil Lake, CanadaNTSB NYC68A0001Accident · 5 fatalClosedRepublic RC-3 · Searsport, MENTSB MIA67A0005Accident · 2 fatalClosedRepublic RC-3 · Jonesboro, GA