NTSB investigations: Grumman American Avn. AA-1B
8 cases on aircraft the registry lists as Grumman American Avn. AA-1B, where the first occurrence was “Loss of engine power”. 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
| 1988 | 1 |
|---|---|
| 1990 | 1 |
| 1995 | 1 |
| 1996 | 1 |
| 1997 | 2 |
| 1998 | 1 |
| 2001 | 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 ('3960103')
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\" = 350))
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 ('3960103')
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" = 350))
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 SEA01LA037Accident · Serious injuriesLimited investigationFinal reportGrumman American AA-1B · Cottage Grove, ORThe flight instructor's failure to ensure (supervision) the student had an adequate supply of fuel available, and the student's failure to refuel the aircraft sufficently resulting in a fuel starvation/exhaustion condition and total power loss. Contributing…NTSB FTW98LA154Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-1B · Tulsa, OKThe complete loss of engine power for an undetermined reason. A factor was the lack of suitable terrain for the forced landing.NTSB MIA97LA209Accident · No injuriesLimited investigationFinal reportGrumman American AA-1B · New Albany, MSa forced landing due to an undetermined complete loss of engine power, and subsequent impact with tress.NTSB IAD97LA097Accident · No injuriesLimited investigationFinal reportGrumman American AA-1B · Culpeper, VAThe pilot's inadequate preflight planning which fail to provide an adequate fuel supplyNTSB LAX97LA008Accident · No injuriesLimited investigationFinal reportGrumman American AA-1B · Kona, HIloss of engine power for undetermined reason(s).NTSB BFO95LA096Accident · Minor injuriesLimited investigationFinal reportGrumman AA-1B · Medina, OHthe pilot's improper planning/decision, which resulted in fuel exhaustion due to an inadequate supply of fuel. High vegetation (tall corn) in the emergency landing area was a related factor.NTSB NYC90LA165Accident · Minor injuriesLimited investigationFinal reportGrumman AA-1 · Highland, NYOff airport landing in unsuitable terrain due to a power loss for unknown reasons.NTSB NYC88LA148Accident · No injuriesLimited investigationFinal reportGrumman AA-1B · Dover, PALoss of engine power for an unknown reason. Contributing factors were: failure of the pilot to maintain runway alignment obstructions near the end of the runway (sign, stone fence & tree).