NTSB investigations: Grumman G-21A
7 cases on aircraft the registry lists as Grumman G-21A, where the first occurrence was “Loss of control - on ground/water”. 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
| 1990 | 1 |
|---|---|
| 1991 | 1 |
| 1993 | 1 |
| 1994 | 1 |
| 2002 | 1 |
| 2004 | 1 |
| 2007 | 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 ('3951204')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 260))
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 ('3951204')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 260))
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 ANC07CA053Accident · No injuriesData collectionFinal reportGrumman G21A · Dutch Harbor, AKThe pilot's inadequate compensation for wind conditions during the takeoff roll, which resulted in a loss of directional control and a nose over.NTSB ANC04LA038Accident · No injuriesLimited investigationFinal reportGrumman G21 · Unalaska, AKThe inadvertent ground loop/swerve by the second pilot during the landing roll, and the first (check) pilot's inadequate supervision of the second pilot, which resulted in a loss of control and substantial damage to the airplane. Factors associated with the…NTSB ANC02LA052Accident · No injuriesLimited investigationFinal reportGrumman G-21 · Northway, AKThe pilot's inadequate compensation for wind conditions during the landing roll, which resulted in an inadvertent ground loop/swerve. A factor associated with the accident was a crosswind.NTSB SEA94LA192Accident · No injuriesLimited investigationFinal reportGrumman G-21A · Bremerton, WAThe pilot-in-command's failure to maintain directional control during landing.NTSB ANC93IA026Incident · No injuriesIncident investigationFinal reportGrumman G-21A · Akutan, AKThe incident was caused by the pilots improper compensation for the winds. Factors were the microburst, the rough water, and the pilot's inadequate evaluation of the weather conditions.NTSB SEA91LA086Accident · No injuriesLimited investigationFinal reportGrumman G-21A · Spokane, WAThe pilot-in-command did not maintain directional control of the airplane. Factors were: the pic's inadequate compensate for the wind, his limited flight expereince in this type of airplane, and the check airman's poor supervision.NTSB ANC90LA102Accident · Minor injuriesLimited investigationFinal reportGrumman G21 · King Salmon, AKThe pilot failed to adequately compensate for the prevailing wind conditions and his failure to maintain directional control. A contributing factor was the strong crosswind component.