NTSB investigations: NONE, 1990
8 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\") = 1990
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") = 1990
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 LAX90LA278Accident · Serious injuriesLimited investigationFinal reportAerostar S-66A · Napa, CAFlight's encounter with a probable microburst weather phenomena with down drafts and winds beyond the performance capability of the balloon.NTSB LAX90LA277Accident · Serious injuriesLimited investigationFinal reportThunder and Colt AX9-140 SLI · Napa, CAFlight's encounter with a probable microburst weather phenomena with down drafts and winds beyond the performance capability of the balloon.NTSB LAX90LA264Accident · Minor injuriesLimited investigationFinal reportRolladen-Schneider LS3-A · Sparks, NVThe inability of the pilot to maintain control of the glider as a result of injuries sustained during an inflight encounter with turbulence. Contributing to the accident was turbulent weather condition encountered.NTSB LAX90LA190Accident · No injuriesLimited investigationFinal reportSchweizer SGS 1-26 · Waialua, HIThe failure of the pilot to maintain an adequate clearance from clouds.NTSB LAX90LA206Accident · Serious injuriesLimited investigationFinal reportThunder and Colt AX9-140 · Napa, CAThe pilot's improper flare technique which resulted in a hard landing. A factor in the accident was the sudden appearance of a high wind condition.NTSB NYC90LA092Accident · Minor injuriesLimited investigationFinal reportSchweizer SGS-1-26B · Unionville, PAThe loss of thermal lift which necessitated a forced landing on unsuitable terrain covered by trees and high obstructions.NTSB ATL90LA104Accident · No injuriesLimited investigationFinal reportBalloon Works 7B · Lexington, KYThe overload failure of several jumper cords. Factor(s) were inadvertent encounter with unfavorable wind (dust devil). Subsequently, the pilot was unable to control the rate of descent.NTSB LAX90LA080Accident · Serious injuriesLimited investigationFinal reportAdams A55 · Glendale, AZImproper planning/decision by the pilot. The unexpected high wind condition was a related factor.