NTSB investigations: NONE, 1995
7 cases on aircraft whose registry engine model is NONE, where the first occurrence was “In flight encounter with weather”. 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 | 1 |
|---|---|
| 1983 | 8 |
| 1984 | 8 |
| 1985 | 6 |
| 1986 | 7 |
| 1987 | 3 |
| 1988 | 5 |
| 1989 | 3 |
| 1990 | 8 |
| 1991 | 4 |
| 1992 | 7 |
| 1993 | 4 |
| 1994 | 4 |
| 1995 | 7 |
| 1996 | 3 |
| 1997 | 3 |
| 1998 | 3 |
| 1999 | 5 |
| 2000 | 3 |
| 2001 | 5 |
| 2002 | 3 |
| 2003 | 4 |
| 2004 | 4 |
| 2005 | 7 |
| 2006 | 5 |
| 2007 | 9 |
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\") = 1995
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\" = 240))
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") = 1995
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" = 240))
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 MIA96LA045Accident · No injuriesLimited investigationFinal reportLet L-23 · Jacksonville, FLThe pilot's failure to properly plan the flight.NTSB FTW96LA001Accident · No injuriesLimited investigationFinal reportAerostar S60A · Baton Rouge, LAThe pilot's failure to compensate for wind conditions and maintain adequate clearance from the power lines during the approach. A factor was the sudden wind gust.NTSB FTW95LA376Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 7 · Colorado Spgs, COAn encounter with a wind shift during landing.NTSB LAX95LA311Accident · Serious injuriesLimited investigationFinal reportElan Glaser Dirks DG-300 Elan · Truckee, CAthe pilot misjudged his planned approach by selecting a touchdown point close to the runway's approach end that did not provide sufficient clearance to safely maneuver when forcast turbulence and downdrafts were encountered. The pilot's early extension of…NTSB NYC95LA182Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 7 · Owego, NYThe pilot's inadequate evaluation of weather conditions which resulted in an encounter with a downdraft, inflight loss of control, and a collision with a vehicle.NTSB FTW95LA326Accident · No injuriesLimited investigationFinal reportGlasflugel Standard Libelle · Red River, NMThe pilot's lack of compensation for the tailwind and his ensuing failure to attain the proper touchdown point. Factors were the lack of thermal lift and the tailwind.NTSB ATL95LA069Accident · Minor injuriesLimited investigationFinal reportAerotek Zuni · Morganton, NCThe pilot's poorly planned approach which resulted in the loss of control of the aircraft because of gusty wind conditions.