NTSB investigations: NONE, 2005, CA
6 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\") = 2005
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") = 2005
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 LAX06CA046Accident · No injuriesData collectionFinal reportCameron Balloons N-180 · Rancho Santa Fe, CAthe pilot's inadvertent deactivation of the number 2 burner, which resulted in an increased rate of descent and a collision with a tree short of the intended landing zone.NTSB LAX06CA021Accident · Minor injuriesData collectionFinal reportDirks Glaser DG-300 · California City, CAthe pilot's inadvertent retraction of the gear and failure to deploy the spoilers, and his subsequent failure to attain a proper touchdown point.NTSB LAX05LA224Accident · 1 fatalLimited investigationFinal reportSchleicher ASW-20 · Big Pine, CAthe pilot's failure to maintain an adequate terrain clearance altitude and his decision to turn toward higher terrain.NTSB LAX05CA190Accident · No injuriesData collectionFinal reportS.A. Centrair Pegase 101D · Williams, CAloss of thermal lift during flight that resulted in a forced landing in an area without suitable landing terrain. Also causal was the pilot's inadequate compensation for the existing crosswind.NTSB LAX05LA162Accident · Serious injuriesLimited investigationFinal reportUltramagic N-250 · Del Mar, CAThe pilot's failure to arrest the high rate of descent and an inadequate bounced landing recovery technique. a factor in the accident was the rough, uneven terrain.NTSB LAX05LA143Accident · Serious injuriesLimited investigationFinal reportFirefly Balloon Firefly 11 · Saint Helena, CAThe pilot's encounter with wind shear during landing, which resulted in a hard touchdown.