NTSB investigations: NONE, 2001, WA
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
| 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
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\") = 2001
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") = 2001
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 SEA01LA153Accident · Serious injuriesLimited investigationFinal reportLet Blanik L-13 · Enumclaw, WAThe premature release of the towline and the pilot's improper selection of a landing area following the release. Factors include improper preflight planning.NTSB SEA01LA150Accident · Minor injuriesLimited investigationFinal reportI.C.A. Brasov IS-28B2 · Wenatchee, WAFailure to maintain clearance from terrain during a low altitude turn. The second pilot overshooting the runway was a contributing factor to the accident.NTSB SEA01LA149Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Quincy, WAThe failure of the impeller assembly as a consequence of impeller rub and binding within the impeller collector case for undetermined reasons.NTSB SEA01LA147Accident · No injuriesLimited investigationFinal reportSchweizer SGS 1-26B · Rock Island, WAThe student pilot's improper inflight planning and decision (delay in establishing an approach to a suitable landing area) and his subsequent failure to attain the proper glidepath for the selected landing area, resulting in an overshoot of the selected…NTSB SEA01LA091Accident · No injuriesLimited investigationFinal reportLet L-23 · Arlington, WAthe flight instructor's improper decision to partially retract the spoilers while the student was attempting to land. Factors include a tailwind, wet grass, and a taxiway sign off the end of the landing area.NTSB SEA01LA081Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Seattle, WAThe high wind conditions encountered as the aircraft began its takeoff roll. Contributing factors were the variable and gusty wind conditions.