NTSB investigations, 2010
24 cases where the sequence of events included Aircraft inspection event.
Cases per year
| 2008 | 9 |
|---|---|
| 2009 | 9 |
| 2010 | 24 |
| 2011 | 12 |
| 2012 | 14 |
| 2013 | 15 |
| 2014 | 15 |
| 2015 | 14 |
| 2016 | 10 |
| 2017 | 12 |
| 2018 | 5 |
| 2019 | 7 |
| 2020 | 12 |
| 2021 | 15 |
| 2022 | 12 |
| 2023 | 14 |
| 2024 | 15 |
| 2025 | 12 |
| 2026 | 3 |
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\") = 2010
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '050' 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") = 2010 AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '050' 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 ERA11LA103Accident · No injuriesLimited investigationFinal reportCessna 152 · Wimauma, FLThe mechanic/pilot's failure to detect a visible exhaust gas leak and cracked cylinder head immediately prior to the accident flight, which resulted in a partial loss of engine power during initial climb. Contributing to the accident was an inadequate…NTSB ANC11CA005Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Clear, AKThe pilot's inadequate preflight inspection, which resulted in a loss of engine power due to water/ice in the fuel system.NTSB WPR11LA081Accident · No injuriesLimited investigationFinal reportApollo AS-III · Poipu, HIThe pilot's lack of compliance with manufacturer's guidance for care and handling of the aircraft combined with incomplete preflight inspections, which resulted in an undetected material failure of the nose cone.NTSB CEN11CA062Accident · No injuriesData collectionFinal reportCessna 172 · Pineville, LAThe pilot/mechanic’s improper inspection of the airplane following the engine installation.NTSB ERA10WA489Accident · No injuriesForeign investigationPiper PA-31-350 · South Bimini, BahamasOn September 19, 2010, at 1440 eastern daylight time, a Piper PA31-350, N84859, registered to Spirit Air Inc, and operated by Pioneer Air Services was on initial climb out when the lower half of the main cabin door came open. The pilot reversed his course and…NTSB WPR10LA483Accident · No injuriesLimited investigationFinal reportBoam Rans S-6S · Roberts, IDA loss of engine power due to the detachment of the left carburetor from the engine inlet manifold. Contributing to the accident was the pilot's failure to address a known engine vibration.NTSB WPR10CA398Accident · Serious injuriesData collectionFinal reportKirkpatrick Buzzard · Lincoln, CAA loss of control due to the mechanical disconnection of an aileron pushrod from its bellcrank as a result of the mechanic's failure to properly secure the pushrod attach hardware. Also causal was the pilot's inadequate preflight inspection.NTSB CEN10CA441Accident · Minor injuriesData collectionFinal reportWolseley Motors SE5-A · Seymour, INA loss of engine power during initial climb due to fuel exhaustion. Contributing to the accident was the pilot's diverted attention while attempting to restart the engine.NTSB WPR10LA366Accident · 1 fatalLimited investigationFinal reportClark RV-9A · Oregon City, ORThe pilot's decision to depart with known mechanical anomalies and the loss of engine power for undetermined reasons.NTSB CEN10IA397Incident · No injuriesIncident investigationFinal reportBell 206 · Gulf of Mexico, LAImproper reassembly of the collective flight controls by maintenance personnel. Contributing to the incident were inadequate postmaintenance examinations by maintenance personnel and inadequate preflight inspections by two pilots.NTSB CEN10CA352Accident · No injuriesData collectionFinal reportAerospatiale AS350 · Lake Charles, LAThe flight instructor’s inadvertent entry into ground resonance when demonstrating a hydraulic failure running landing, which resulted in substantial damage to the helicopter. Contributing to the accident was the pilot's and instructor pilot's failure to…NTSB ERA10LA351Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Thomasville, GAThe improper reinstallation of the airplane’s oleo piston assembly during an annual inspection, resulting in the collapse of the right main landing gear during touchdown.NTSB ERA10LA301Accident · No injuriesLimited investigationFinal reportHood John Sidney Tango · New Port Richey, FLThe improper inspection of the airplane ignition system during the last condition inspection by a mechanic, resulting in an ignition cable disconnecting and a partial loss of engine power.NTSB ERA10IA285Incident · No injuriesIncident investigationFinal reportCessna 560XL · White Plains, NYThe flight crew's failure to ensure that the cabin door was secured/locked prior to takeoff.NTSB CEN10LA245Accident · Minor injuriesLimited investigationFinal reportGross Cozy · Pine Bluff, ARThe inadvertent opening of the cockpit canopy during cruise flight for undetermined reasons, which allowed debris to impact and damage the pusher propeller with a resulting total loss of engine power.NTSB CEN10IA169Incident · No injuriesIncident investigationFinal reportSikorsky S-92A · Galliano, LAAn unsecured access door, which departed the helicopter and damaged a main rotor blade and a tail rotor blade. Contributing to the incident was the helicopter's color scheme, which made visual inspection of the door difficult.NTSB WPR10LA161Accident · Serious injuriesLimited investigationFinal reportHead Balloons AX9 118 · Phoenix, AZThe pilot’s improper preflight inspection of the balloon’s rapid deflation system, which resulted in its inhibited functionality during landing.NTSB WPR10CA164Accident · No injuriesData collectionFinal reportEurocopter AS 350 B3 · Parker, AZThe mechanics' failure to account for all the tools following a maintenance procedure and the pilot's failure to perform a preflight check before a maintenance test flight.NTSB CEN10LA159Accident · Minor injuriesLimited investigationFinal reportCessna TU206 · Ninnekah, OKA loss of engine power due to fuel exhaustion, resulting from the pilot’s inadequate preflight inspection.NTSB CEN10CA138Accident · Serious injuriesData collectionFinal reportEnstrom 280FX · Goshen, INThe inadequate preflight inspection by both pilots, resulting in a loss of engine power due to fuel exhaustion. Contributing to the accident was the disconnected fuel tank sending unit.NTSB CEN10FA122Accident · 2 fatalField investigationFinal reportPiper PA-30 · Amarillo, TXThe pilot’s failure to detect water contaminated fuel, which resulted in a loss of engine power shortly after takeoff. Contributing to the accident were the worn and loose fuel caps, which allowed water to enter the fuel tanks.NTSB ERA10TA142Accident · No injuriesFinal reportEurocopter AS 365 N2 Dauphin · Cheverly, MDIncomplete clearing of snow from the helipad and vicinity. Contributing to the accident was the lack of a NOTAM regarding the presence of snow banks and the pilot's failure to ensure that the helicopter was clear of a snow bank prior to departure.NTSB CEN10FA107Accident · 2 fatalField investigationFinal reportCostruzioni Aeronautiche Tecna P2002 · Waxahachie, TXA loss of aircraft control while maneuvering for undetermined reasons.NTSB ENG10IA016Incident · No injuriesIncident investigationFinal reportDouglas DC8 · Cincinnati (CVG), OHFailure of the NLG cylinder occurred by intergranular rupture; coincidental to a chrome plating crack. The failure origin occurred along the inner surface of the cylinder and then propagated by stress corrosion cracking to the outer surface. A secondary crack…