NTSB investigations: Republic RC-3, FL
12 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
| 1964 | 1 |
|---|---|
| 1966 | 1 |
| 1969 | 2 |
| 1970 | 1 |
| 1973 | 2 |
| 1979 | 1 |
| 1985 | 1 |
| 1988 | 1 |
| 1990 | 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.\"eventStateOrRegion\" = 'FL' 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" = 'FL' 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 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 MIA90LA187Accident · Serious injuriesLimited investigationFinal reportRepublic RC-3 · Mulberry, FLAn engine failure which required an emergency landing off airport.NTSB MIA89LA005Accident · Minor injuriesLimited investigationFinal reportRepublic RC-3 · Miami, FLThe pilot stated that he was having problems with the elevator trim and elected to land the amphibious acft in the bay. He acknowledged and witnesses observed him lower the landing gear prior to attempting to land on the water. The aircraft flipped inverted…NTSB MIA85LA116Accident · No injuriesLimited investigationFinal reportRepublic RC-3 · Lake Placid, FLThe plt heard a loud noise & noticed that a fire had immediately started in the eng compartment. He made an emergency landing on a nearby lake; however, the amphibious acft continued burning & was destroyed. An investigation revealed that the fire had started…NTSB MIA79DLA27Accident · No injuriesClosedRepublic RC3 · Perry, FLNTSB MIA74DLD44Accident · Minor injuriesClosedRepublic RC-3 · Umatilla, FLNTSB MIA74FKT36Accident · No injuriesClosedRepublic RC-3 · Dania, FLNTSB MIA71DLD33Accident · No injuriesClosedRepublic RC-3 · Winter Haven, FLNTSB MIA70F0163Accident · Serious injuriesClosedRepublic RC-3 · Jacksonville, FLNTSB MIA69D0403Accident · No injuriesClosedRepublic RC-3 · Lake Placid, FLNTSB MIA66F0500Accident · No injuriesClosedRepublic RC-3 · Fransvilla, FLNTSB UNK64X3740Accident · Serious injuriesClosedRepublic RC3 · Eliott Key, FL