NTSB investigations: Beech 19A, 1987
2 cases on aircraft the registry lists as Beech 19A. 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
| 1968 | 9 |
|---|---|
| 1969 | 6 |
| 1970 | 10 |
| 1971 | 9 |
| 1972 | 3 |
| 1973 | 7 |
| 1974 | 7 |
| 1975 | 3 |
| 1976 | 2 |
| 1977 | 1 |
| 1978 | 3 |
| 1979 | 1 |
| 1980 | 1 |
| 1981 | 4 |
| 1983 | 1 |
| 1984 | 3 |
| 1985 | 1 |
| 1986 | 2 |
| 1987 | 2 |
| 1988 | 1 |
| 1989 | 1 |
| 1992 | 2 |
| 1993 | 2 |
| 1994 | 1 |
| 2003 | 2 |
| 2005 | 1 |
| 2006 | 2 |
| 2009 | 1 |
| 2010 | 1 |
| 2011 | 1 |
| 2016 | 1 |
| 2017 | 2 |
| 2022 | 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 year(c.\"eventDate\") = 1987
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1151214'))
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 year(c."eventDate") = 1987
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1151214'))
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 NYC88LA019Accident · Minor injuriesLimited investigationFinal reportBeech 19A · Buena, NJa loss of electrical power for undetermined reasons, which necessitated a precautionary landing. Factors were rain, clouds, dark night, and the pole. This report was modified on February 9, 2005.NTSB DEN87LA143Accident · No injuriesLimited investigationFinal reportBeech 19A · Erie, COThe instructor (CFI) was instructing the student plt, who was the new owner of the acft. The CFI rprtd the acft was 'very close to gross weight due to having so much fuel aboard and the density altitude was high.' He estd the density altitude was 7600 ft. drg…