NTSB investigations: Grumman G-44, AK
16 cases on aircraft the registry lists as Grumman G-44. 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
| 1963 | 1 |
|---|---|
| 1964 | 1 |
| 1966 | 1 |
| 1967 | 1 |
| 1968 | 1 |
| 1972 | 1 |
| 1973 | 1 |
| 1978 | 1 |
| 1984 | 1 |
| 1995 | 2 |
| 1998 | 1 |
| 2006 | 1 |
| 2011 | 1 |
| 2012 | 1 |
| 2020 | 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\" = 'AK' 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 ('3951502'))
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" = 'AK' 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 ('3951502'))
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 ANC20CA045Accident · No injuriesClass 4 · Data collectionFinal reportGrumman G44 · Anchorage, AKThe pilot's failure to extend the landing gear for a runway landing, which resulted in a gear-up landing.NTSB ANC13FA001Accident · 1 fatalField investigationFinal reportGrumman G-44 · Aleknagik, AKThe pilot's decision to make multiple low passes over the glassy surface water, which resulted in an impact with the surface of the lake.NTSB ANC11LA084Accident · No injuriesLimited investigationFinal reportGrumman G-44 · Dillingham, AKA loss of directional control during landing due to a rock lodged in the main landing gear wheel brake, resulting in a runway excursion and collision with terrain.NTSB ANC06CA063Accident · No injuriesData collectionFinal reportGrumman G-44 · Willow, AKThe pilot's failure to retract the amphibian airplane's main landing gear prior to landing on a lake, which resulted in a nose over during touchdown.NTSB ANC98LA138Accident · No injuriesLimited investigationFinal reportGrumman G-44 · Dillingham, AKThe pilot's failure to maintain clearance with terrain. Contributing factors were the pilot's delayed remedial action (course reversal), low ceilings, rain, fog, and mountainous terrain.NTSB ANC95LA122Accident · No injuriesLimited investigationFinal reportGrumman G-44 · Kodiak, AKOverload failure of the main landing gear wheel.NTSB ANC95LA071Accident · No injuriesLimited investigationFinal reportGrumman G-44 · Dillingham, AKThe pilot's failure to refuel the airplane, and his improper remedial action(s) which lead to fuel starvation.NTSB ANC84LA126Accident · No injuriesLimited investigationFinal reportGrumman G-44A · Shanin Lake, AKThe plt reported that shortly after takeoff the acft encountered severe wind shear. The plt lost directional control of the acft & it collided with a mud bank.NTSB ANC78DA020Accident · Serious injuriesClosedGrumman G-44 · Pilot Point, AKNTSB ANC74AA031Accident · No injuriesClosedGrumman G-44S · Farewell, AKNTSB ANC73AA007Accident · No injuriesClosedGrumman G-44 · Kodiak, AKNTSB ANC69F0091Accident · Serious injuriesClosedGrumman G-44A · Sanak Island, AKNTSB ANC68A0030Accident · No injuriesClosedGrumman G-44 · Kodiak, AKNTSB ANC67D0070Accident · No injuriesClosedGrumman G-44 · Iliamna, AKNTSB UNK65X0677Accident · No injuriesClosedGrumman G-44 · Cape Alitak, AKNTSB ANC64A0005Accident · No injuriesClosedGrumman G-44 · Seldovia, AK