NTSB investigations: Grumman G-21A, CA
21 cases on aircraft the registry lists as Grumman G-21A. 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
| 1962 | 1 |
|---|---|
| 1964 | 2 |
| 1965 | 1 |
| 1966 | 1 |
| 1967 | 1 |
| 1968 | 1 |
| 1969 | 2 |
| 1970 | 3 |
| 1971 | 2 |
| 1975 | 1 |
| 1976 | 2 |
| 1977 | 1 |
| 1979 | 2 |
| 1990 | 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\" = 'CA' 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 ('3951204'))
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" = 'CA' 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 ('3951204'))
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 LAX90LA221Accident · Serious injuriesLimited investigationFinal reportGrumman G21A · Long Beach, CAThe pilot's failure to retract the landing gear resulting in an inadvertent wheels-down landing in water. In addition, a loss of elevator control was encountered due to a stress corrosion failure of an elevator control cable turnbuckle as a result of…NTSB LAX79FA084Accident · 1 fatalClosedGrumman G-21A · Avalon, CANTSB LAX79FA040Accident · 1 fatalClosedGrumman G-21A · Catalina Is, CANTSB LAX77FUA17Accident · No injuriesClosedGrumman G-21A · Catalina, CANTSB LAX76IL081Incident · No injuriesClosedGrumman G-21A · Long Beach, CANTSB LAX76AL068Accident · No injuriesClosedGrumman G-21A · Avalon, CANTSB LAX76IL006Accident · No injuriesClosedGrumman G-21 · Long Beach, CANTSB LAX72AL071Accident · Minor injuriesClosedGrumman G-21 · Long Beach, CANTSB LAX72AL009Accident · No injuriesClosedGrumman G-21A · Avalon, CANTSB LAX71AL034Accident · Serious injuriesClosedGrumman G-21A · Lakewood, CANTSB LAX70AL046Accident · Minor injuriesClosedGrumman G-21A · Avalon, CANTSB LAX70AL040Accident · No injuriesClosedGrumman G-21A · Avalon, CANTSB OAK70A0013Accident · Minor injuriesClosedGrumman G-21A · Avalon, CANTSB LAX70A0010Accident · No injuriesClosedGrumman G-21A · Avalon, CANTSB LAX69A0016Accident · 1 fatalClosedGrumman G-21 · Avalon, CANTSB LAX67A0074Accident · No injuriesClosedGrumman G-21A · Long Beach, CANTSB LAX66A0091Accident · No injuriesClosedGrumman G-21 · Catalina Is, CANTSB LAX65F0060Accident · Serious injuriesClosedGrumman G21A · Avalon, CANTSB UNK64X2803Accident · No injuriesClosedGrumman G21A · Avalon, CANTSB UNK64X1555Accident · No injuriesClosedGrumman G21 · Avalon Bay, CANTSB LAX62A0073Accident · No injuriesClosedGrumman G-21A · Avalon Bay, CA