NTSB investigations: Taylorcraft BL-65, 1987
2 cases on aircraft the registry lists as Taylorcraft BL-65. 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
| 1964 | 3 |
|---|---|
| 1965 | 2 |
| 1966 | 2 |
| 1967 | 2 |
| 1968 | 1 |
| 1969 | 2 |
| 1970 | 3 |
| 1971 | 2 |
| 1972 | 2 |
| 1973 | 3 |
| 1974 | 1 |
| 1975 | 3 |
| 1976 | 1 |
| 1977 | 1 |
| 1978 | 3 |
| 1979 | 1 |
| 1980 | 1 |
| 1981 | 3 |
| 1982 | 1 |
| 1983 | 1 |
| 1984 | 1 |
| 1985 | 2 |
| 1986 | 1 |
| 1987 | 2 |
| 1988 | 2 |
| 1990 | 1 |
| 1993 | 1 |
| 1994 | 1 |
| 1998 | 2 |
| 2008 | 1 |
| 2011 | 2 |
| 2013 | 1 |
| 2014 | 1 |
| 2016 | 1 |
| 2021 | 1 |
| 2022 | 1 |
| 2023 | 1 |
| 2026 | 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 ('8850350'))
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 ('8850350'))
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 MIA87LA180Accident · No injuriesLimited investigationFinal reportTaylorcraft BL-65 · Deland, FLThe plt stated that just after take-off, the rt wing was lifted by a x-wind & the acft stalled & crashed into the trees. The plt stated that the accident could have been prevented if he had decreased the angle of attack after take-off & had made 'a turn into…NTSB MKC87FA121Accident · Serious injuriesField investigationFinal reportTaylorcraft BL-65 · Hope, ARThe PIC had last student certificate and medical in 1978. On this flight with passenger, takeoff was made from rough hay meadow, 1372 feet long. When airplane could not climb over powerline at end of meadow, pilot decided to fly under powerline. Right wing…