NTSB investigations, IL
19 cases where NTSB found Temp/humidity/pressure.
Cases per year
| 2008 | 3 |
|---|---|
| 2010 | 1 |
| 2011 | 4 |
| 2012 | 1 |
| 2013 | 1 |
| 2014 | 2 |
| 2016 | 3 |
| 2017 | 1 |
| 2018 | 1 |
| 2019 | 1 |
| 2022 | 1 |
Where
Open the mapLatest 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.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '030310'))
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."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '030310')) 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 CEN22LA370Accident · Serious injuriesClass 4 · LimitedFinal reportBurkhart Grob Flugzeugbau G102 Club Astir Iiib · Highland, ILThe glider’s encounter with atmospheric conditions where the lift was not sufficient to maintain flight.NTSB CEN19LA216Accident · Minor injuriesClass 3 · LimitedFinal reportRutan Varieze · Kaneville, ILThe pilot's failure to use carburetor heat while operating at low power settings in conditions conducive to the development of carburetor ice, and the subsequent total loss of engine power due to carburetor icing.NTSB GAA18CA397Accident · Minor injuriesData collectionFinal reportRobert Miles Smith Trike · Lewiston, ILA total loss of engine power due to the pilot's failure to apply carburetor heat in conditions conducive to carburetor icing and his subsequent failure to maintain directional control during a forced landing.NTSB CEN17LA145Accident · No injuriesLimited investigationFinal reportCessna 120 · Columbia, ILThe partial loss of engine power due to carburetor icing.NTSB GAA17CA109Accident · No injuriesData collectionFinal reportPiper PA28R · Kewanee, ILThe pilot’s failure to extend the landing gear during the approach to land.NTSB CEN16LA299Accident · No injuriesLimited investigationFinal reportEngineering & Research 415 C · Mt Morris, ILThe pilot's loss of airplane control during a forced landing in gusting crosswind conditions and the airplane’s subsequent bounce on the runway following a loss of engine power. Contributing to the accident was the loss of engine power due to carburetor icing.NTSB CEN16LA166Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Brimfield, ILA loss of engine power for reasons that could not be determined, as postaccident examination of the engine did not reveal any anomalies that would have precluded normal operation.NTSB CEN15LA021Accident · No injuriesLimited investigationFinal reportRaytheon 58 · Dixon, ILThe pilots’ improper decision to continue flight in icing conditions after the deicing boots could not shed accumulated ice, which resulted in a temporary loss of airplane control.NTSB CEN14LA134Accident · No injuriesLimited investigationFinal reportCessna 172K · Milan, ILThe pilot’s delayed use of carburetor heat while operating the airplane in atmospheric conditions conducive to carburetor icing, which resulted in a total loss of engine power due to carburetor icing during a short final approach.NTSB CEN13LA398Accident · Minor injuriesLimited investigationFinal reportFlight Design Ctls · Sandwich, ILThe pilot’s failure to recognize the formation of carburetor ice during cruise descent and apply carburetor heat, which resulted in the total loss of engine power.NTSB CEN12CA599Accident · No injuriesData collectionFinal reportCessna 152 · Rockford, ILA partial loss of engine power for reasons that could not be determined because postaccident examination of the engine revealed no anomalies.NTSB CEN11CA547Accident · Minor injuriesData collectionFinal reportLuscombe 8 · Poplar Grove, ILThe pilot's decision to not use all available runway length and his failure to abort the takeoff.NTSB CEN11CA486Accident · Minor injuriesData collectionFinal reportHamlin John D CH701 · Paxton, ILThe pilot's decision to takeoff with a tailwind in high density altitude conditions.NTSB CEN11CA199Accident · No injuriesData collectionFinal reportCessna 310Q · Romeoville, ILThe pilot's failure to maintain adequate airspeed during the approach/landing to compensate for the ice accumulated on the airframe which resulted in a hard landing.NTSB CEN11FA144Accident · Minor injuriesField investigationFinal reportGates Learjet 35A · Springfield, ILThe pilot’s decision to conduct an instrument approach in icing conditions without the anti-ice system activated, contrary to the airplane flight manual guidance, which resulted in an inadvertent aerodynamic stall due to an in-flight accumulation of airframe…NTSB CEN10CA252Accident · No injuriesData collectionFinal reportPiper J3C-65 · Sandwich, ILThe pilot's delay in using carburetor heat resulting in a partial loss of engine power due to carburetor icing.NTSB CHI08CA276Accident · Minor injuriesData collectionFinal reportCessna 150J · Spring Grove, ILThe pilot's inadequate preflight planning and his failure to maintain clearance from the trees. Contributing factors were the trees and the high density altitude.NTSB CHI08CA237Accident · Serious injuriesData collectionFinal reportPowrachute PC 2000 · Goodfield, ILThe insufficient aircraft performance data available to the pilot and the inadequate preflight planning/preparation by the pilot. Contributing to the accident were the trees and density altitude.NTSB CHI08LA134Accident · Serious injuriesLimited investigationFinal reportCessna 150M · Palestine, ILThe loss of engine power due to carburetor icing. Contributing to the accident were the pilot's decision to conduct a low-power spiraling descent operation during conditions conducive to carburetor icing, and the weather that was conducive to carburetor icing.