NTSB investigations: Gulfstream American AA-5B, NJ
4 cases on aircraft the registry lists as Gulfstream American AA-5B. 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
| 1983 | 1 |
|---|---|
| 1987 | 1 |
| 1988 | 2 |
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\" = 'NJ' 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 ('3970106'))
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" = 'NJ' 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 ('3970106'))
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 NYC89LA008Accident · Serious injuriesLimited investigationFinal reportAmerican AA-5B · Wrightstown, NJThe plt said that the battery ran low while he was attempting to start his acft. He said he hand-propped the eng for several minutes and when he became fatigued, the passenger, who is also a pilot, began to hand prop the eng. When the passenger turned the…NTSB NYC88LA135Accident · No injuriesLimited investigationFinal reportGrumman AA5B · Morristown, NJA loss of control due to improper technique after a bounced landing. Contributing was the second pilot also attempting to correct the situation.NTSB NYC88LA023Accident · No injuriesLimited investigationFinal reportGulfstream American AA-5B · Morristown, NJThe Gulfstream-american AA5B was making a takeoff with a flight instructor and student pilot on board. At 65 knots during the takeoff, a deer was struck on the runway and killed. The takeoff was aborted on the runway. The student pilot and flight instructor…NTSB NYC84LA043Accident · No injuriesLimited investigationFinal reportGulfstream American AA-5B · Morristown, NJEarlier in the evening, the plt had taken off with 3 passengers on board. Shortly after takeoff, he advised the tower that the eng was not developing full power. He remained in the traffic pattern & landed, then taxied to the ramp. Later, the plt made a 2nd…