NTSB investigations, 1982, IL
9 cases where the first occurrence was “Hard landing”.
Cases per year
| 1982 | 9 |
|---|---|
| 1983 | 10 |
| 1984 | 8 |
| 1985 | 4 |
| 1986 | 5 |
| 1987 | 3 |
| 1988 | 7 |
| 1989 | 5 |
| 1990 | 7 |
| 1991 | 1 |
| 1992 | 4 |
| 1993 | 2 |
| 1994 | 6 |
| 1995 | 3 |
| 1996 | 4 |
| 1997 | 3 |
| 1998 | 3 |
| 1999 | 2 |
| 2001 | 3 |
| 2002 | 3 |
| 2003 | 7 |
| 2004 | 4 |
| 2005 | 3 |
| 2006 | 2 |
| 2007 | 3 |
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\") = 1982
AND c.\"eventStateOrRegion\" = 'IL' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE 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") = 1982 AND c."eventStateOrRegion" = 'IL' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 200) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
Run 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 CHI82DA339Accident · Serious injuriesFinal reportRutan Varieze · Litchfield, ILThe pilot had received 20 minutes of instruction in this aircraft prior to his solo flight. The pilot made 8-10 passes at the runway prior to his landing attempt. On approach the aircraft stalled and impacted the runway causing the main gear to collapse.NTSB CHI82DA293Accident · No injuriesFinal reportCessna 152 · Belvidere, ILThe student pilot was practicing touch-and-go landings. On his last landing, the nosewheel struck the ground hard. He reported that there was damage to the nosewheel, and firewall and the engine and propeller were bent.NTSB CHI82DA344Accident · No injuriesFinal reportCessna 150J · Dekalb, ILThe student pilot was practicing touch-and-go landings. He stated that on about his sixth landing, he touched down hard on the main gear then lowered the nose. As the nose wheel touched down, the aircraft veered to the left and the right wing contacted the…NTSB CHI82DA249Accident · No injuriesFinal reportCessna 150J · Alton, ILThe student and instructor pilot (ip) were departing on an instructional flight. Immediately after takeoff, the ip retarded the throttle to simulate an engine failure. The student lowered the nose to maintain airspeed, then prematurely raised it again. The ip…NTSB CHI82DA175Accident · No injuriesFinal reportCessna R182 · Cahokia, ILThe pilot was making touch and go landings on runway 30 with a wind from about 180 degrees at 11 KTS. On the fourth landing, the aircraft bounced two or three times. The plane slid sideways, went off the runway, and the nose gear failed.NTSB CHI82DA158Accident · No injuriesFinal reportCessna 150 · Bloomington, ILThe pilot stated that base and final approach at Bloomington-normal airport seemed smooth at 80 mph. At 8 ft above the runway the throttle was reduced to idle. Immediately at throttle reduction, the aircraft dropped to the runway landing on the main gear. The…NTSB CHI82DA153Accident · No injuriesFinal reportCessna 152 · Peoria, ILThe pilot departed mt hawley airport for greater Peoria airport to practice touch and go landings. His first approach was high and he made a go-around. He reported that his second approach was a bit too high, but he elected to continue since the runway was…NTSB CHI82DA132Accident · No injuriesFinal reportBeech BE-23 · West Chicago, ILThe pilot stated that during landing flare the aircraft dropped rapidly striking the runway on the main gear. It then bounced back into the air and landed on the nose gear which collapsed.NTSB CHI82DA045Accident · No injuriesFinal reportSikorsky UH-19B · Urbana, ILThe pilot and a medical attendant were on a flight to Urbana to make a medical evacuation. The pilot stated that just prior to touchdown, the helicopter began to rotate to the left. He reported that he landed immediately, cut the power, and stopped the…