NTSB investigations: NONE, 2002
6 cases on aircraft whose registry engine model is NONE, where the first occurrence was “In flight collision with object”. 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
| 1982 | 6 |
|---|---|
| 1983 | 8 |
| 1984 | 5 |
| 1985 | 7 |
| 1986 | 5 |
| 1987 | 3 |
| 1988 | 6 |
| 1989 | 11 |
| 1990 | 7 |
| 1991 | 6 |
| 1992 | 2 |
| 1993 | 7 |
| 1994 | 3 |
| 1995 | 1 |
| 1996 | 8 |
| 1997 | 6 |
| 1998 | 3 |
| 1999 | 3 |
| 2000 | 4 |
| 2001 | 8 |
| 2002 | 6 |
| 2003 | 4 |
| 2004 | 6 |
| 2005 | 6 |
| 2006 | 5 |
| 2007 | 5 |
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\") = 2002
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')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 220))
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") = 2002
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')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 220))
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 NYC03LA013Accident · Serious injuriesLimited investigationFinal reportAvian Balloon Skyhawk · Cottageville, WVThe pilot's improper decision not to over fly the landing area, which resulted in an in-flight collision with power lines.NTSB LAX02LA208Accident · Serious injuriesLimited investigationFinal reportWSK PZL Swidnik PW-5 · Loch Lomand, CAthe pilot's inadequate compensation for wind conditions, and his failure to maintain clearance with trees during final approach. A contributing factor was the windshear and turbulence encountered during the approach.NTSB IAD02LA042Accident · No injuriesLimited investigationFinal reportWSK PZL PW-5 · New Smithville, PAThe pilot's inadequate evaluation of the weather which resulted in the loss of thermal lift and collision with trees.NTSB LAX02LA079Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Warner Springs, CAThe student pilot's failure to maintain directional control during the landing sequence.NTSB LAX02FA069Accident · 1 fatalField investigationFinal reportCameron Balloons US N-145 · North Las Vegas, NVThe pilot's misjudged approach and inadequate obstacle clearance, which resulted in his failure to attain the proper touchdown point. Contributing factors were the high gusty wind condition, and the pilot's failure to provide protective safety equipment.NTSB FTW02LA270Accident · Serious injuriesLimited investigationFinal reportRaven S60A · La Vernia, TXThe pilot's improper planning of the approach and failure to maintain clearance with the powerlines. A factor was the power lines.