NTSB investigations: Cessna A150K, 1987
4 cases on aircraft the registry lists as Cessna A150K. 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
| 1969 | 3 |
|---|---|
| 1970 | 10 |
| 1971 | 10 |
| 1972 | 12 |
| 1973 | 6 |
| 1974 | 4 |
| 1975 | 4 |
| 1976 | 1 |
| 1977 | 2 |
| 1978 | 5 |
| 1979 | 3 |
| 1980 | 1 |
| 1981 | 2 |
| 1982 | 1 |
| 1983 | 5 |
| 1984 | 2 |
| 1985 | 2 |
| 1986 | 2 |
| 1987 | 4 |
| 1988 | 1 |
| 1990 | 2 |
| 1992 | 1 |
| 1993 | 1 |
| 1994 | 1 |
| 1997 | 2 |
| 2000 | 2 |
| 2001 | 1 |
| 2003 | 1 |
| 2007 | 1 |
| 2012 | 1 |
| 2021 | 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 ('2071824'))
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 ('2071824'))
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 CHI88LA023Accident · No injuriesLimited investigationFinal reportCessna A150K · Elkhart, INThe plt of Cessna A150K, N8382M, was landing after the plt of another Cessna 150 had landed & had started to back-taxi up the same rwy. The plt of the other acft stated that she had announced her intentions to back taxi up the rwy & that she did not hear any…NTSB ANC88LA009Accident · Minor injuriesLimited investigationFinal reportCessna A150K · Whittier, AKThe PIC got lost while flying above an overcast. When he finally found an opening and descended below the clouds he was low on fuel. He located some buildings on a narrow beach and attempted to land. He overshot the beach and struck stacks of building…NTSB CHI87FA129Accident · 2 fatalField investigationFinal reportCessna A150K · Scotts, MIThe airplane had been circling a residence at tree top level when a witness saw the nose drop and the acft descend steeply toward the terrain. The airplane struck a power line before ground impact.NTSB MKC87FA048Accident · 1 fatalField investigationFinal reportCessna A150K · West Memphis, ARThe airplane was making low passes over the edge of a trailer park and at the end of each pass, it would climb almost straight up and then make a steep banked turn and dive for another pass. At the end of the last pullup, the airplane made an abrupt steep…