NTSB investigations: NONE, 1986, WA
3 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
| 1968 | 1 |
|---|---|
| 1969 | 1 |
| 1971 | 1 |
| 1973 | 2 |
| 1975 | 2 |
| 1976 | 4 |
| 1977 | 2 |
| 1978 | 4 |
| 1980 | 1 |
| 1981 | 1 |
| 1982 | 1 |
| 1984 | 4 |
| 1985 | 1 |
| 1986 | 3 |
| 1987 | 1 |
| 1992 | 3 |
| 1993 | 3 |
| 1994 | 1 |
| 1995 | 2 |
| 1996 | 1 |
| 1998 | 2 |
| 2001 | 6 |
| 2003 | 2 |
| 2004 | 2 |
| 2005 | 1 |
| 2006 | 1 |
| 2008 | 1 |
| 2010 | 1 |
| 2011 | 1 |
| 2014 | 1 |
| 2016 | 1 |
| 2019 | 1 |
| 2020 | 1 |
| 2021 | 1 |
| 2022 | 2 |
| 2025 | 1 |
| 2026 | 1 |
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\") = 1986
AND c.\"eventStateOrRegion\" = 'WA' 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") = 1986
AND c."eventStateOrRegion" = 'WA' 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 SEA86LA199Accident · No injuriesLimited investigationFinal reportSchweizer 2-22EK · Easton, WAThe instructor pilot was flying the glider with a student in the front seat on a local instructional flight. About 2200 ft down the 2640 foot grass strip, the tow aircraft, at about 50 to 100 feet AGL, lost power and started to descend back to the runway. The…NTSB SEA86FA211Accident · Serious injuriesField investigationFinal reportSchweizer SGS-2-33 · Toledo, WAThe weak link at the tow vehicle broke during launching. The plt lowered the nose of the acft and turned into the wind. The plt stated that the acft was stalled and that he was unable to stop the descent rate. The acft struck the runway in a slight nose down…NTSB SEA86LA147Accident · No injuriesLimited investigationFinal reportAvian Skyhawk · Yakima, WAA forced landing was made due to fuel starvation. During the forced landing the balloon struck power lines, severing the basket from the envelope. Sparks from the wire strike caused a small brush fire. Post accident exam revealed the plt inadvertently…