NTSB investigations: NONE, 1985
6 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\") = 1985
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") = 1985
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 DEN86LA006Accident · Minor injuriesLimited investigationFinal reportSkypower GBN-41-100 · Pecos, NMFlt was participation in the 1985 balloon fiesta, a night helium-filled balloon race from albuquerque, new Mexico, to elkhart, Kansas. One hr after launch plt encountered small wind shear, causing loss of altitude, ballast, and helium. Plt then encountered…NTSB LAX85LA394Accident · No injuriesLimited investigationFinal reportGlasflugel ST Liebelle 201B · California City, CAThe glider landed off the arpt on a road and groundlooped after colliding with shrubbery. The plt complained of encountering a downdraft during the flt.NTSB DEN85LA234Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 7 · Littleton, COThe plt attempted to land his Balloon in high winds resulting a hard ldg which threw him out of the basket the Balloon then began an immediate asent until a pax pulled the vent line and the Balloon settled rapidly until it hit the grd. Injuries to passengers…NTSB BFO85LA053Accident · Serious injuriesLimited investigationFinal reportSchweizer 2-33A · Warrenton, VAAfter liftoff both the PIC and the plt getting checked out in the Schweizer sgs 2-33A stated that they encountered moderate turbulence in the area. When the sailplane reched approximately 200 ft AGL the tom rope separated from the aircraft and N65818 was…NTSB NYC85LA157Accident · No injuriesLimited investigationFinal reportSchweizer SGS 1-26 · Cambria, NYThe glider, while returning to land after a pleasure flt, encounter a rainshower and strong downdraft. The plt made a landing in a farmers fld. During the landing the right wing caught and the acft ground looped, incurring substantial damage.NTSB MKC85LA048Accident · No injuriesLimited investigationFinal reportRaven Rally RX7 · Davenport, IABalloon encountered gust during initial climb and began drifting toward wires. Plt elected to deflate & balloon collided with wires & building.