NTSB investigations: Grumman SCAN TYPE 30
9 cases on aircraft the registry lists as Grumman SCAN TYPE 30. 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 |
|---|---|
| 1969 | 1 |
| 1971 | 2 |
| 1972 | 1 |
| 1977 | 1 |
| 1983 | 1 |
| 1989 | 1 |
| 2004 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('3951602'))
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 ('3951602'))
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 ANC05LA003Accident · No injuriesLimited investigationFinal reportScan 30 · Anchorage, AKAn in-flight fire during cruise flight for an undetermined reason.NTSB MIA89LA191Accident · No injuriesLimited investigationFinal reportGrumman G-44 · Pahokee, FLThe pilot's inadvertent loss of airplane control, while on the water, which resulted in a swerve and subsequent accident.NTSB CHI83FA362Accident · Minor injuriesField investigationFinal reportGrumman Scan Type 30 · Fond Du Lac, WIAfter takeoff, the aircrew flew to the southern end of lake winnebago where they made several uneventful water landings. They estimated that the wind was from the northeast at 5 to 6 KTS. The water was described as smooth with only small ripples. On the 6th…NTSB MIA77FKT43Accident · No injuriesClosedGrumman G-44A · Okeechobee, FLNTSB OAK73DJY03Accident · No injuriesClosedGrumman G44 · Majuro, MontserratNTSB OAK71FJA16Accident · No injuriesClosedGrumman SCAN30 · Majuro, MontserratNTSB OAK71FJA11Accident · No injuriesClosedGrumman SCAN30 · Ebeye, MontserratNTSB ANC70A0005Accident · 2 fatalClosedGrumman G-44A · Barrow, AKNTSB LAX67D0036Accident · No injuriesClosedGrumman G-44A · Havasu City, AZ