NTSB investigations: Jacobs R755B series, 1988
2 cases on aircraft whose registry engine model is Jacobs R755B series. 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 | 5 |
|---|---|
| 1965 | 4 |
| 1966 | 1 |
| 1967 | 4 |
| 1968 | 4 |
| 1969 | 1 |
| 1970 | 3 |
| 1971 | 6 |
| 1972 | 1 |
| 1973 | 3 |
| 1974 | 2 |
| 1975 | 2 |
| 1976 | 5 |
| 1977 | 4 |
| 1978 | 1 |
| 1979 | 2 |
| 1980 | 3 |
| 1981 | 4 |
| 1982 | 2 |
| 1983 | 1 |
| 1984 | 1 |
| 1985 | 2 |
| 1986 | 1 |
| 1987 | 2 |
| 1988 | 2 |
| 1989 | 3 |
| 1990 | 3 |
| 1991 | 3 |
| 1992 | 1 |
| 1993 | 1 |
| 1994 | 5 |
| 1995 | 3 |
| 1996 | 1 |
| 1997 | 3 |
| 1998 | 5 |
| 1999 | 3 |
| 2001 | 3 |
| 2002 | 1 |
| 2003 | 2 |
| 2004 | 4 |
| 2005 | 3 |
| 2006 | 1 |
| 2007 | 3 |
| 2009 | 1 |
| 2010 | 1 |
| 2011 | 2 |
| 2012 | 2 |
| 2013 | 3 |
| 2014 | 1 |
| 2015 | 1 |
| 2016 | 2 |
| 2017 | 1 |
| 2018 | 1 |
| 2019 | 1 |
| 2023 | 1 |
| 2024 | 1 |
| 2025 | 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\") = 1988
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('35007'))
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") = 1988
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('35007'))
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 DEN88LA173Accident · Serious injuriesLimited investigationFinal reportCessna 195B · Watkins, COThe new owner of the acft was receiving flt training from an instructor (CFI) & they were practicing landings. Drg a landing roll-out, the acft began to veer to the right. The CFI took the controls to avoid running off the rwy, then took off & flew another…NTSB MIA88LA220Accident · No injuriesLimited investigationFinal reportClassic YMF-5 · Key West, FLWhile turning the acft around at the operator's establishment after completing a sightseeing flt, the lower left wing collided with a vehicle.