NTSB investigations: Grumman American Avn. AA-1B, PA
15 cases on aircraft the registry lists as Grumman American Avn. AA-1B. 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
| 1973 | 2 |
|---|---|
| 1974 | 1 |
| 1975 | 2 |
| 1977 | 3 |
| 1978 | 1 |
| 1979 | 1 |
| 1981 | 1 |
| 1988 | 1 |
| 1996 | 1 |
| 2012 | 1 |
| 2015 | 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\" = 'PA' 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 ('3960103'))
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" = 'PA' 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 ('3960103'))
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 ERA15LA276Accident · No injuriesLimited investigationFinal reportGrumman American Avn. AA1B · Lititz, PAA partial loss of engine power for reasons that could not be determined because postaccident examination of the engine found no mechanical malfunctions or failures that would have precluded normal operation.NTSB ERA12CA523Accident · No injuriesData collectionFinal reportGrumman American Avn. AA-1B · Bedford, PAThe pilot's failure to maintain control of the airplane during the landing and subsequent go-around. Contributing to the accident was the pilot's failure to shutoff the carburetor heat during the attempted go-around and the weight at which the airplane was…NTSB NYC96LA170Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-1B · Tafton, PAThe pilot's misjudgment of speed and distance during the landing.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).NTSB NYC81FGT13Accident · No injuriesClosedAmer Avco AA-1B · Marietta, PANTSB NYC79FA030Accident · 2 fatalClosedGrum Amer AA-1B · Milroy, PANTSB NYC78FGM47Accident · No injuriesClosedGrum Amer AA1-B · Mckeesport, PANTSB NYC77FGM36Accident · No injuriesClosedGrum Amer AA1-B · Pittsburgh, PANTSB NYC77FHA32Accident · No injuriesClosedGrum Amer AA1-B · Yardley, PANTSB NYC77FHD16Accident · Minor injuriesClosedGrum Amer AA1-B · Bristol, PANTSB NYC76DHD12Accident · No injuriesClosedGrum Amer AA1-B · Bristol, PANTSB NYC76FGT03Accident · No injuriesClosedGrum Amer AA1-B · New Oxford, PANTSB NYC74FHD24Accident · No injuriesClosedAmer Avco AA1-B · Bristol, PANTSB NYC74DHD11Accident · Minor injuriesClosedAmer Avco AA1-B · Bristol, PANTSB NYC73FGT10Accident · Minor injuriesClosedAmer Avco AA-1B · Frackville, PA