NTSB investigations, 2018
16 cases where the sequence of events included Preflight or dispatch event.
Cases per year
| 2008 | 23 |
|---|---|
| 2009 | 32 |
| 2010 | 29 |
| 2011 | 28 |
| 2012 | 19 |
| 2013 | 28 |
| 2014 | 25 |
| 2015 | 31 |
| 2016 | 29 |
| 2017 | 25 |
| 2018 | 16 |
| 2019 | 7 |
| 2020 | 12 |
| 2021 | 11 |
| 2022 | 7 |
| 2023 | 14 |
| 2024 | 3 |
| 2025 | 10 |
| 2026 | 6 |
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 year(c.\"eventDate\") = 2018
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '030' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
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") = 2018 AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '030' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 CEN19FA021Accident · 1 fatalField investigationFinal reportCessna 210 · Bradley, SDThe non-instrument-rated pilot's improper decision to conduct a flight in which instrument meteorological conditions existed along the route of flight, which resulted in spatial disorientation and a loss of airplane control.NTSB CEN19FA005Accident · 1 fatalField investigationFinal reportPiper PA28 · Cartersville, GAThe pilot's inadequate preflight and inflight fuel planning and his decision to continue flight without stopping for fuel, which resulted in a total loss of engine power due to fuel exhaustion.NTSB ERA19LA004Accident · Serious injuriesLimited investigationFinal reportPiper PA 24-180 · Smithville, TNA total loss of engine power during initial climb due to carburetor ice that formed during an extended ground delay.NTSB CEN18FA384Accident · 2 fatalField investigationFinal reportCessna 150 · Festus, MOA total loss of engine power due to fuel exhaustion and the pilot's subsequent exceedance of the airplane's critical angle of attack, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's decision to initiate and continue the…NTSB WPR18LA259Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Roche Harbor, WAThe pilot’s failure to secure his seat position prior to takeoff, which resulted in a loss of airplane control and subsequent hard landing.NTSB CEN18FA336Accident · 1 fatalField investigationFinal reportCessna 172 · Rhome, TXThe pilot's inadequate maintenance of the airplane, which resulted in a total loss of engine power due to fuel starvation when organic debris restricted available fuel to the carburetor, and the pilot's impairment due to the ingestion of alcohol, which…NTSB CEN18LA334Accident · No injuriesClass 3 · LimitedFinal reportSchweizer 269C · Kindred, NDThe pilot’s failure to adequately inspect the lower coupling driveshaft during his preflight inspection and his non-compliance with an applicable airworthiness directive, which resulted in the failure of the forward drive splines of the lower coupling…NTSB ERA18LA199Accident · 1 fatalLimited investigationFinal reportCessna 182 · Cleveland, TNThe undetected wear of the ignition switch and key, which allowed removal of the key from an intermediate position and subsequently led to an unintended engine start-up. Contributing to the undetected wear of the 42-year-old ignition switch was the lack of…NTSB GAA18CA430Accident · No injuriesData collectionFinal reportRobinson R44 · Okawville, ILThe pilot's improper preflight weight and balance calculation, which resulted in his operating the helicopter over its maximum gross takeoff weight and in its subsequent failure to climb.NTSB ERA18LA164Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA 44 · Daytona Beach, FLThe pilots’ improper in-flight weather evaluation and decision to continue the approach, which resulted in an encounter with a thunderstorm, a loss of airplane control, and collision with terrain. Contributing to the accident was the flight instructor’s…NTSB ERA18LA158Accident · No injuriesClass 3 · LimitedFinal reportBellanca 7ECA · Warsaw, KYThe pilot’s inadequate preflight performance planning, and his delayed decision to abort the takeoff, which resulted in a ground loop.NTSB ANC18FA036Accident · 1 fatalClass 2 · FieldFinal reportPiper PA-28-180 · Whittier, AKThe student pilot's decision to depart and continue on a solo cross-country flight through mountainous terrain in marginal visual flight rules conditions, which resulted in controlled flight into terrain.NTSB ERA18LA140Accident · Minor injuriesLimited investigationFinal reportRobinson R22 · Panama City, FLThe pilot's failure to properly remove and secure the tie-down ropes during the preflight inspection, which resulted in the ropes becoming entangled in the rotor head swashplate and pitch control rods during flight and the subsequent loss of pitch control.NTSB CEN18LA146Accident · Minor injuriesLimited investigationFinal reportCessna T303 · Pine Ridge, SDThe airplane’s inadvertent encounter with severe icing conditions during descent, which resulted in structural icing, the pilot’s inability to maintain altitude, and an emergency landing. Contributing to the accident was an incomplete preflight weather…NTSB CEN18FA144Accident · 2 fatalField investigationFinal reportCirrus Design SR22 · Williamsburg, PAThe pilot's failure to obtain an updated weather briefing before the flight and his subsequent loss of airplane control due to spatial disorientation while maneuvering in instrument meteorological conditions during a diversion to an alternate airport after…NTSB ANC18FA024Accident · 1 fatalField investigationFinal reportMooney M20 · Chuckanut, WAThe pilot's failure to maintain clearance from terrain during a visual approach in dark night visual meteorological conditions, which resulted in controlled flight into terrain.