NTSB investigations: NONE, 1985
7 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
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\" = 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") = 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" = 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 NYC85LA254Accident · Minor injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Preble, NYA Schweizer N33920, collided with a utility pole while executing a go around at Preble airport, NY. The acft was destroyed. The plt and passenger received minor injuries. The plt stated that the first two flights were uneventful, but noticed the stall speed…NTSB CHI85LA367Accident · Serious injuriesLimited investigationFinal reportRaven AX-9 · Blaine, MNThe one hour balloon sightseeing flight was uneventful. During his approach to land in a clear area he decided that his forward velocity was too high to land without hitting houses or powerlines below the balloon. According to him he burned fuel to attempt a…NTSB ANC85LA140Accident · No injuriesLimited investigationFinal reportBalloon Works Firefly 8 · Anchorage, AKWhile the plt was approaching a field to land, the wind shifted & gusted, blowing the Balloon toward a light standard. The envelope grazed the standard, ripping the material near the top of the Balloon. The Balloon then landed in the field. The wind was…NTSB DEN85FA196Accident · Serious injuriesField investigationFinal reportBalloon Works Firefly 7 · Brighton, COA hot air Balloon owned and flown by the plt collided with electrical power lines during an attempted landing. The basket of the Balloon caught fire upon contact with the wires. The occupants leaped from the burning basket sustaining serious injuries. The…NTSB DEN85LA127Accident · Serious injuriesLimited investigationFinal reportRaven S77A · Fort Collins, COThe balloon basket containing 8 pass'g & 2 crewmembers brushed alongside a fence during lndg. One pass'g who had been jostled by the landing became a victim of 1ACERATIONS & a broken arm from contact with barbed wire fence. The plt stated that the wind was…NTSB MIA85LA093Accident · Minor injuriesLimited investigationFinal reportMonerai S-P · Immokalee, FLThe plt was making an apch to a grass portion of the arpt not usually used for acft. The glider contacted pwr lines during the apch and subsequently collided wtih the terrain. The plt stated he never saw the pwr lines before contacting them.NTSB MIA85LA072Accident · Serious injuriesLimited investigationFinal reportRaven S-60A · Pompano Beach, FLThe balloon envelope struck a palm tree and a building while landing. The basket turned over when it contacted the ground. A passenger was injured when another passenger fell on her as the basket turned over.