Fatal NTSB investigations, IL
12 cases where the first occurrence was “Loss of engine power(total) - nonmechanical”.
Cases per year
| 1982 | 1 |
|---|---|
| 1983 | 2 |
| 1987 | 1 |
| 1989 | 1 |
| 1990 | 1 |
| 1992 | 1 |
| 1994 | 1 |
| 1995 | 1 |
| 1997 | 1 |
| 2004 | 1 |
| 2006 | 1 |
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 c.\"eventStateOrRegion\" = 'IL' AND c.\"eventCountry\" = 'USA'
AND c.\"highestInjuryLevel\" = 'Fatal'
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\" = 353)
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 c."eventStateOrRegion" = 'IL' AND c."eventCountry" = 'USA' AND c."highestInjuryLevel" = 'Fatal' 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" = 353) 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 CHI06FA224Accident · 1 fatalField investigationFinal reportAmerican Legend AL11C · Chicago, ILThe failure of both pilots to assure that the fuel cap was securely in place prior to takeoff which resulted in fuel siphoning and untimately fuel exhaustion. An additional cause was the decision to fly over the lake outside of gliding distance to shore along…NTSB CHI05LA004Accident · 1 fatalLimited investigationFinal reportMalone Vans RV-6A · Joliet, ILThe total loss of engine power due to fuel exhaustion as a result of the pilot's inadequate preflight and inadequate fuel consumption calculations, also causal was the pilot's failure to maintain aircraft control during the forced landing. A factor was the…NTSB CHI97FA133Accident · 1 fatalField investigationFinal reportPiper PA-38-112 · Savoy, ILthe pilot's improper preflight planning/preparation and her not maintaining airspeed. Factors were fuel exhaustion and entering an inadvertent stall.NTSB CHI95FA212Accident · 1 fatalField investigationFinal reportTaylorcraft BC-65 · Plato Center, ILthe pilot not maintaining an adequate fuel supply, and not maintaining airspeed.NTSB CHI94FA202Accident · 2 fatalField investigationFinal reportBell 47G2 · Baldwin, ILThe inadequate maintenance (inspection of aircraft) by maintenance personnel, which resulted in a loss of engine power due to fuel exhaustion. Related factors are the unsafetied fuel filter, and low altitude at which the helicopter operated.NTSB CHI92FA279Accident · 4 fatalField investigationFinal reportCessna 177 · Manlius, ILThe pilot-in-command's failure to maintain control of the airplane during a forced landing, and his inadequate preflight which resulted in fuel exhaustion and power loss.NTSB CHI90DEE10Accident · 1 fatalFinal reportJeff Pierson Pierson Pusher · Kankakee, ILA loss of engine power due to activation of carburetor choke and an inadvertent stall during the forced landing.NTSB CHI89GA048Accident · 2 fatalFinal reportPiper PA-28-180 · Chicago, ILInadequate preflight of the aircraft by the pilot, which resulted in fuel exhaustion due to an inadequate supply of fuel. Factors related to the accident were: high obstructions and retaining wall in the emergency landing area.NTSB CHI88FA035Accident · 1 fatalField investigationFinal reportBeech 58 · Wedron, ILThe airplane struck trees and descended uncontrolled into a river while attempting a night forced landing after running out of fuel during a cargo flight. The airplane was found under water on the fifth day of a search conducted by the cap after two boys…NTSB CHI84FA051Accident · 1 fatalField investigationFinal reportBeech V35B · Cairo, ILThe acft dove into the ground nose first from a 90 degree bank shortly after takeoff. The acft was observed by witnessesto take off slowly 'with about 1/2 power' being used. The climb was slow and at 300-400 ft the acft turned left with thelanding gear still…NTSB CHI83FA075Accident · 3 fatalField investigationFinal reportMooney M-20D · Lindenwood, ILAt 0306 the plt contacted rockford fss requesting local wx. He then requested an ILS apch to rockford & stated he had noapproach plates. After being cleared for an ILS apch to rwy 36, the plt reported he was unable to pick up the ILS & was low on fuel. ARTCC…NTSB CHI83LA062Accident · 1 fatalLimited investigationFinal reportScorpion Too · Sandwich, ILThe rotorcraft impacted the runway very hard with no flare after the engine quit 100-200 feet AGL. The pilot had no training in this aircraft. No fuel was found in the fuel tank and no fuel odors were present. An examination of the fuelsystem, engine and…