NTSB investigations: NONE, 1985, CA
5 cases on aircraft whose registry engine model is NONE. 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 | 4 |
|---|---|
| 1965 | 3 |
| 1966 | 5 |
| 1967 | 8 |
| 1968 | 5 |
| 1969 | 8 |
| 1970 | 9 |
| 1971 | 7 |
| 1972 | 9 |
| 1973 | 12 |
| 1974 | 10 |
| 1975 | 6 |
| 1976 | 5 |
| 1977 | 7 |
| 1978 | 4 |
| 1979 | 5 |
| 1980 | 5 |
| 1981 | 4 |
| 1982 | 5 |
| 1983 | 12 |
| 1984 | 6 |
| 1985 | 5 |
| 1986 | 7 |
| 1987 | 2 |
| 1988 | 9 |
| 1989 | 4 |
| 1990 | 14 |
| 1991 | 8 |
| 1992 | 8 |
| 1993 | 3 |
| 1994 | 5 |
| 1995 | 5 |
| 1996 | 6 |
| 1997 | 5 |
| 1998 | 1 |
| 1999 | 3 |
| 2000 | 2 |
| 2001 | 1 |
| 2002 | 5 |
| 2003 | 6 |
| 2004 | 1 |
| 2005 | 6 |
| 2006 | 3 |
| 2007 | 6 |
| 2008 | 4 |
| 2009 | 6 |
| 2010 | 2 |
| 2011 | 4 |
| 2012 | 3 |
| 2013 | 3 |
| 2014 | 2 |
| 2015 | 2 |
| 2016 | 3 |
| 2017 | 1 |
| 2018 | 1 |
| 2019 | 2 |
| 2020 | 2 |
| 2021 | 2 |
| 2022 | 1 |
| 2026 | 5 |
Where
Latest 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\") = 1985
AND c.\"eventStateOrRegion\" = 'CA' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('00000'))
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") = 1985
AND c."eventStateOrRegion" = 'CA' AND c."eventCountry" = 'USA'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('00000'))
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 LAX85LA394Accident · No injuriesLimited investigationFinal reportGlasflugel ST Liebelle 201B · California City, CAThe glider landed off the arpt on a road and groundlooped after colliding with shrubbery. The plt complained of encountering a downdraft during the flt.NTSB LAX85LA233Accident · No injuriesLimited investigationFinal reportSchweizer SGS1-36 · Hemet, CAThis was the first flight after a cockpit check-out in the Schweizer sgc 1-36. The pilot released from the tow plane when he realized that the spoilers were deployed and landed short of the runway. The pilot reported that the spoiler handle in this model…NTSB LAX85FUG03Accident · Serious injuriesFinal reportVickers Slingsby T56A Vega · Hemet, CAThe sailplane was in level flt when the plt felt flutter and lost pitch control of the acft. After one uncontrolled loop the plt bailed out and received serioud injuries during the parachute landing. Loss of all six elevator hinges had caused the elevator to…NTSB LAX85LA209Accident · No injuriesLimited investigationFinal reportBurkhart Grob G103 Twin Astir · Hemet, CAThe plt attempted to land the glider near the rwy threshold in order to be ready for an immediate relaunch. He reported that he was aware of vegetation, located along the edge of the rwy, but said that he misjudged its height. The right wing contacted the…NTSB LAX85LA223Accident · Serious injuriesLimited investigationFinal reportGeneral Balloon AX-6 · Panamint Valley, CAThe plt reported that he was landing on desert terrain in nearly calm air when a 'strong thermal wind pushed the balloon 90 degrees from the direction of track.' Subsequently, the balloon landed hard & was dragged about 150 ft across the desert. While…