NTSB investigations: NONE, 1983
8 cases on aircraft whose registry engine model is NONE, where the first occurrence was “Hard landing”. 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 | 5 |
|---|---|
| 1983 | 8 |
| 1984 | 6 |
| 1985 | 3 |
| 1986 | 5 |
| 1987 | 2 |
| 1988 | 3 |
| 1989 | 2 |
| 1990 | 3 |
| 1991 | 5 |
| 1992 | 4 |
| 1993 | 4 |
| 1994 | 8 |
| 1995 | 7 |
| 1996 | 3 |
| 1997 | 7 |
| 1998 | 7 |
| 1999 | 4 |
| 2000 | 3 |
| 2001 | 7 |
| 2002 | 4 |
| 2003 | 6 |
| 2004 | 5 |
| 2005 | 4 |
| 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\") = 1983
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\" = 200))
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") = 1983
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" = 200))
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 DEN84LA035Accident · No injuriesLimited investigationFinal reportSchweizer SGS1-36 · Colorado Spring, COThe plt reported that during his apch to land, the glider encountered turbulence. He stated that he was 'unable to maintain directional control on landing contact with ground.' The glider touched down in a left yaw. Shortly after touchdown, he regained…NTSB LAX84LA070Accident · Serious injuriesLimited investigationFinal reportCameron A-140 · Temecula, CAThe plt reported that he had received wx info from the tv, but no wx report was obtained from flt service. When he took off on a sight-seeing flt at 0745 PST, the wind was calm. After takeoff, he flew at lower altitudes, then climbed & flew between 1200 &…NTSB LAX84LA063Accident · Serious injuriesLimited investigationFinal reportRider AA-4 · Salome, AZThe plt of the balloon was making a precautionary landing due to his proximity to the mexican border. To avoid high tension wires, the plt 'ripped out' at a higher than normal altitude resulting in a hard landing. The plt received a fractured skull when he…NTSB DEN84LA043Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 7 · Monte Vista, COThe plt was participating in a 'hare & hounds' Balloon contest. The aircrews were wx briefed at the launch site before the event. Reportedly, there was a front approaching but it was not expected to move thru until about 2 to 3 hrs after the contest.…NTSB CHI84LA015Accident · Serious injuriesLimited investigationFinal reportAdams AB · Wyoming, MIThe balloon collided with the ground, bounced, hit a house and a utility pole before being torn enough to come to rest. The hard landing in an 8 kt wind tore the vent line from the pilots hand, he lost the ability to vent the balloon and during the collisions…NTSB LAX83LA170Accident · Serious injuriesLimited investigationFinal reportRaven AX-9 · Mesa, AZAccording to the plt, there was no wind when he began the sight-seeing flt; however, after takeoff, the wind steadily increased to aprx 12 KTS. By this time, the balloon was approaching a large green field, so he elected to land rather than take a chance of…NTSB FTW83LA155Accident · Serious injuriesLimited investigationFinal reportPiccard AX-6 · Springtown, TXThe balloon was on a 'hare & hound' competition flight with a commercial plt & student plt on board. After the competition portion was completed, the pilot-in-command told the student to take control & continue flying, then land at her discretion. After about…NTSB MKC83LA051Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 7B · Indianola, IAThe pilot elected to make a touch and go landing in wind that was from 010 deg at 7, gusting 9 KTS. During touchdown, the basket was drifting and tilted over sideways. The passenger weithed 290 lbs and was unable to maintain his balance. When the basket…