NTSB investigations
229 cases where the sequence of events included Aircraft inspection event.
Cases, newest first
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.\"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 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 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…NTSB CEN10LA078Accident · Serious injuriesLimited investigationFinal reportBell Helicopter Textron Canada 407 · Decatur, TXThe pilot's inadequate preflight inspection and the momentary loss of engine power due to snow or ice ingestion.NTSB CEN09CA559Accident · No injuriesData collectionFinal reportNavion Navion G · Eau Claire, MIA loss of engine power due to fuel starvation as a result of the pilot's inadequate fuel management.NTSB ERA09LA370Accident · Serious injuriesLimited investigationFinal reportMichael J. Kohout Glassair III · Manassas, VAThe pilot's failure to maintain aircraft control while attempting an emergency landing after takeoff. Contributing to the accident was the pilot's inadequate preflight inspection and distraction due to a separated fuel cap in flight.NTSB CEN09CA337Accident · No injuriesData collectionFinal reportCarillon John C Zodiac CH6 · Clinton, ARThe pilot's failure to maintain control of the aircraft during takeoff. Contributing to the accident was his failure to secure a wing fuel panel prior to departure.NTSB ANC09LA038Accident · Minor injuriesLimited investigationFinal reportCessna TU206 · Bethel, AKThe pilot’s failure to remove visible frost from the wings during the preflight inspection, and his failure to maintain adequate airspeed to avoid a stall. Contributing to the accident were conditions conducive to structural icing/frost.NTSB ERA09LA257Accident · No injuriesLimited investigationFinal reportMaule M-5-180C · Moultrie, GAA loss of engine power due to carburetor icing as a result of the maintenance technician's failure to detect and correct the condition of the carburetor heat duct.NTSB CEN09IA234Incident · No injuriesIncident investigationFinal reportBell 206L-3 · Abilene, TXThe formation and propagation of a fatigue crack in the trailing edge of the main rotor blade due to interconnected porosity and resultant corrosion. The area of interconnected porosity was due to a manufacturing defect which was not detected during the…NTSB CEN09CA218Accident · No injuriesData collectionFinal reportBell 222 · Milliken, COThe separation of the left engine cowling for undetermined reasons.NTSB WPR09FA102Accident · 2 fatalField investigationFinal reportSiai-Marchetti SF-260C · Santa Monica, CAThe pilot’s failure to select the proper fuel tank for takeoff, which resulted in a loss of engine power. Contributing to the accident was the pilot's failure to maintain aircraft control while attempting a return to runway maneuver.NTSB ANC09LA017Accident · No injuriesLimited investigationFinal reportCessna 207A · Hoonah, AKThe pilot's failure to ensure that the aft cargo door was properly latched and locked prior to departure, which resulted in an in-flight opening of the aft cargo door and subsequent damage to the airplane.NTSB ERA09LA015Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Kissimmee, FLThe pilot's inadequate preflight inspection, which resulted in a total loss of engine power during initial climb due to fuel contamination. Contributing to the accident was a fuel tank cap that did not seal properly.NTSB MIA08LA197Accident · Serious injuriesLimited investigationFinal reportBerrie Kolb Mark III · East Haddam, CTThe pilot's improper preflight inspection of the airplane. Contributing to the accident was water contamination of the fuel.NTSB MIA08LA187Accident · No injuriesLimited investigationFinal reportPiper J5A · Atlanta, GAThe loss of pitch control due to slippage of the elevator control cable resulting from the maintenance personnel’s improper installation and inspection of the cable.NTSB DFW08LA209Accident · No injuriesLimited investigationFinal reportEvektor Aerotechnik Sportstar · St Charles, MOThe student pilot's failure to maintain control due to his task saturation as a result of his failure to set the pitch trim to the neutral position before takeoff.NTSB NYC08LA255Accident · Serious injuriesLimited investigationFinal reportCessna 402B · Ocean Ridge, FLA partial loss of engine power due to fuel starvation. Contributing to the accident was the pilot’s decision to add only a limited amount of fuel prior to the flight, and the fuel selector valve placards' inaccurate depiction of the airplane fuel tank…NTSB CHI08IA182Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas MD-81 · St. Louis, MOThe inadvertent partial inflation of the evacuation slide within the tailcone during takeoff and subsequent binding of the elevator control cables. The partial inflation resulted from the tailcone evacuation slide cover failing to be secured to the floor…NTSB ENG08IA051Incident · No injuriesIncident investigationFinal reportBoeing 737 · Phoenix (PHX), AZThe failure of the MLG was due to cracking in the cylinder wall resulting from a fatigue mechanism which initiated at, and near the inner diameter (ID) surface, with propagation through the wall toward the outer diameter(OD) surface. Crack initiation was due…NTSB NYC08LA165Accident · 1 fatalLimited investigationFinal reportDragon Fly GT-500 · Paris, TNA fuel system configuration that was not in accordance with the engine manufacturer's published guidance, which resulted in a complete loss of engine power due to fuel starvation.