NTSB investigations: Republic RC-3, MI
6 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
| 1965 | 1 |
|---|---|
| 1966 | 1 |
| 1969 | 1 |
| 1970 | 1 |
| 1982 | 1 |
| 1986 | 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\" = 'MI' 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 ('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."eventStateOrRegion" = 'MI' 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 ('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 CHI86LA203Accident · Minor injuriesLimited investigationFinal reportRepublic RC-3 · Keego Harbor, MIAccording to the pilot, as he was preparing to land on a lake and was at an altitude of approximately 100 feet, he noticed that he did not have full flaps down. He then reached down, and by error, lowered the landing gear instead of the flaps. During…NTSB CHI82DA246Accident · No injuriesFinal reportRepublic RC-3 · Saginaw, MIThe pilot stated that he took off with 35 gal of fuel aboard. After about 128 nautical miles, the engine lost power. While landing in a muddy corn field with the gear retracted, the aircraft slid a short distance then nosed over. One of the first persons to…NTSB CHI71FDW04Accident · Serious injuriesClosedRepublic RC-3 · Port Huron, MINTSB CHI70D0223Accident · No injuriesClosedRepublic RC-3 · Port Austin, MINTSB CHI67F0145Accident · Serious injuriesClosedRepublic RC-3 · Walloon Lake, MINTSB CHI66F0063Accident · No injuriesClosedRepublic RC-3 · Muskegon, MI