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 ERA22LA215Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 414 · Connellsville, PAThe pilot/mechanic’s failure to properly secure two airplane avionics units, which resulted in the trays supporting the units to sag downward and become lodged in the movement area of the elevator bellcrank during the accident takeoff.NTSB ERA22LA200Accident · Serious injuriesClass 4 · LimitedFinal reportTitan T51 · Perry, FLThe pilot’s inadequate preflight inspection of the fuel quantity, which resulted in fuel exhaustion, a subsequent total loss of engine power, and an off-airport landing.NTSB ERA22LA194Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-28-140B · Panama City, FLA total loss of engine power due to fuel contamination. Contributing to the accident was the inadequate maintenance and inspection of the airplane and engine by maintenance personnel, and the pilot’s inadequate preflight inspection and runup.NTSB ERA22FA189Accident · 1 fatalClass 3 · FieldFinal reportSchleicher ASW-19B · Jacksonville, FLThe pilot’s improper preflight assembly of the glider’s elevator control, which resulted in a loss of control on takeoff, and the pilot’s failure to complete a positive control check before the flight, which would have identified the disconnected elevator…NTSB ERA22LA198Accident · No injuriesClass 3 · LimitedFinal reportCessna 310 · Selma, ALThe failure of maintenance personnel to properly rig the rudder trim system after reinstallation and pilot’s inadequate preflight inspection after recent maintenance, which resulted in an inability to adequately maintain directional control during the flight.NTSB WPR22LA130Accident · No injuriesClass 4 · LimitedFinal reportParadise Aircraft USA P1 · Glendale, AZA total loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot's inadequate preflight fuel inspection.NTSB ERA22LA080Accident · Serious injuriesClass 4 · LimitedFinal reportPiper PA-12 · Labelle, FLThe pilot’s improper fuel system modification, which resulted in a loss of engine power due to fuel exhaustion.NTSB CEN21LA461Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-32-260 · Hancock, MNA total loss of engine power as a result of fuel starvation. Contributing to the accident was the pilot’s failure to properly manage the fuel on board the airplane and his failure to perform an adequate preflight inspection.NTSB CEN21LA423Accident · No injuriesClass 4 · LimitedFinal reportMooney M20J · Howell, MIThe pilot’s inadequate preflight inspection of the airplane’s fuel quantity, which resulted in a total loss of engine power due to fuel starvation.NTSB ERA21LA360Accident · No injuriesClass 3 · LimitedFinal reportZenith 750 Cruzer · New Smyrna, FLThe mechanic’s inadequate inspection of the flight control system, which resulted in a loss of airplane control.NTSB ERA21LA361Accident · Minor injuriesClass 3 · LimitedFinal reportBeech C24R · Augustine, FLImproperly installed fuel injection system components, which resulted in a partial loss of engine power shortly after takeoff.NTSB CEN21LA419Accident · Minor injuriesClass 4 · LimitedFinal reportThatcher CX4 · Marshalltown, IAThe pilot’s failure to properly determine the correct fuel quantity during preflight inspection that resulted in a loss of engine power during approach due to fuel exhaustion.NTSB ERA21LA393Accident · No injuriesClass 4 · LimitedFinal reportVans RV8 · Delray, FLThe pilot’s inadequate preflight inspection and improper fuel planning which resulted in fuel exhaustion and subsequent loss of engine power.NTSB CEN21LA365Accident · No injuriesClass 4 · LimitedFinal reportVans RV6 · Urbana, OHThe pilot’s inadequate preflight inspection and fuel planning which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN21FA272Accident · 2 fatalClass 3 · FieldFinal reportAntenor Velazco Lancair Evolution · Parker, COThe pilot’s diversion of attention following an asymmetric flap deployment, which resulted in a descent and collision with powerlines. Contributing to the accident was maintenance personnel’s failure to properly secure the flap control rod attachment bolts,…NTSB ERA21LA228Accident · Minor injuriesClass 4 · LimitedFinal reportRobert Trembly JA20 Highlander · Central City, KYThe pilot’s failure to properly secure the left wing fuel cap before flight, which resulted in a loss of engine power due to fuel exhaustion.NTSB CEN21LA191Accident · No injuriesClass 4 · LimitedFinal reportCessna 150 · Caro, MIThe pilot's inadequate preflight inspection and fuel planning and improper in-flight decision-making, which resulted in a total loss of engine power due to fuel exhaustion.NTSB ERA21LA169Accident · No injuriesClass 4 · LimitedFinal reportCessna 150L · Hardwick Township, NJThe pilot’s inadequate prefight inspection, during which he failed to detect water contamination in the fuel system, which resulted in a total loss of engine power.NTSB CEN21LA174Accident · Minor injuriesClass 3 · LimitedFinal reportBeech 95-B55 (T42A) · Colby, KSThe pilot’s failure to remove the towbar from the nose landing gear before takeoff, which resulted in a sustained adverse yaw condition, and his failure to adequately monitor the fuel system while circling the airport, which resulted in fuel starvation and…NTSB ANC21LA022Accident · No injuriesClass 3 · LimitedFinal reportCessna A185F · Skwentna, AKInstallation of improper hardware on the ski check cable. Contributing to the accident was the inadequate inspection of the ski yokes, which resulted in the subsequent failure of the right main landing gear ski yoke and collapse of the right main landing gear…NTSB ERA21FA142Accident · 1 fatalClass 3 · FieldFinal reportLuscombe 8E · Jupiter, FLThe pilot’s exceedance of the airplane’s critical angle of attack, which led to an aerodynamic stall and loss of control. Contributing to the accident was the pilot’s inadequate preflight inspection of the airplane, resulting in an unsecured engine cowl that…NTSB WPR21LA022Accident · No injuriesClass 4 · LimitedFinal reportPiper J3-C65 · El Cajon, CAThe pilot's inadequate preflight inspection and fuel planning which resulted in a total loss of engine power due to fuel exhaustion.NTSB ERA20LA332Accident · No injuriesClass 3 · LimitedFinal reportGlasair 1RG · Hagerstown, MDThe pilot's inadequate preflight inspection and fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN20LA377Accident · No injuriesClass 3 · LimitedFinal reportStinson 108-3 · Coleman, MIThe pilot’s improper installation of the generator drive gear, which resulted in a total loss of engine power.NTSB CEN20CA331Accident · No injuriesClass 4 · Data collectionFinal reportCessna A188 · Hartington, NEThe pilot's failure to ensure that the engine oil cap was installed before takeoff, which resulted in the oil obscuring the pilot’s view through the windshield and necessitated a forced landing on unsuitable terrain. Contributing to the accident were the…NTSB CEN20LA292Accident · No injuriesClass 3 · LimitedFinal reportBeech A23-24 · Burns Flat, OKThe mechanic’s improper maintenance when he reinstalled the fuel servo during the last annual inspection, which resulted in a loss of engine power during cruise flight when the throttle control rod-end disconnected from the fuel servo throttle linkage.NTSB CEN20LA207Accident · No injuriesClass 3 · LimitedFinal reportIcon A5 · Duluth, MNThe pilot’s failure to remove an object from the airplane’s exterior, which impacted the propeller blades when he applied full power, causing them to fracture and damage the airplane.NTSB CEN20CA181Accident · Serious injuriesClass 4 · Data collectionFinal reportCessna 172 · Colchester, ILThe pilot's inadequate preflight of the fuel quantity which resulted in a loss of engine power due to fuel starvation during cruise flight.NTSB CEN20LA162Accident · Minor injuriesClass 2 · LimitedFinal reportCessna T210 · New Braunfels, TXThe pilot's inadequate preflight inspection and fuel planning, which resulted in the loss of engine power due to fuel exhaustion.NTSB CEN20LA132Accident · Serious injuriesClass 3 · LimitedFinal reportCessna T210 · Waxahachie, TXThe partial loss of engine power due to water and contaminants in the fuel, due to the pilot’s inadequate preflight inspection, and the pilot’s decision to conduct a steep turn at low altitude to return to the runway rather than land straight ahead, which…NTSB CEN20CA090Accident · No injuriesData collectionFinal reportRobinson R22 · Cotulla, TXThe pilot's failure to remove the right skid trailer tie-down before attempting to take off, which resulted in a dynamic roll-over.NTSB ERA20CA102Accident · No injuriesData collectionFinal reportCessna 172 · Rochester, NYThe pilot's failure to maintain airplane control during a go-around. Contributing to the accident was the pilot’s decision to take off after perceiving a rudder issue during taxi operations.NTSB CEN20LA053Accident · Minor injuriesClass 3 · LimitedFinal reportCessna T210 · Ada, OKThe pilot’s inadequate fuel management, which resulted in a total loss of engine power due to fuel starvation, and the pilot’s inadequate preflight inspection and preflight fuel planning.NTSB WPR20CA056Accident · Serious injuriesData collectionFinal reportCosmos Phase II · Lake Havasu City, AZThe total loss of engine power due to fuel exhaustion, which resulted from the pilot's inadequate preflight fuel inspection.NTSB GAA20CA089Accident · No injuriesData collectionFinal reportCessna 172 · DuBois, PAThe pilot's improper fuel management, which resulted in fuel starvation and a total loss of engine power, and his subsequent improper landing flare, which resulted in a hard, bounced landing. Contributing to the accident were the pilot's improper preflight…NTSB ERA20LA035Accident · No injuriesClass 3 · LimitedFinal reportBeech 55 · Griffin, GAThe pilot’s failure to ensure that the airplane was properly configured for takeoff, which resulted in the inadvertent retraction of the landing gear during the takeoff roll and the airplane’s subsequent runway excursion.NTSB CEN19LA252Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA28 · Miami, FLThe flight instructor's and student pilot's inadequate preflight inspection of the fuel system for water contamination, which resulted in a loss of engine power during takeoff and subsequent forced landing.NTSB GAA19CA372Accident · No injuriesData collectionFinal reportCessna T206 · Porterville, CAThe pilot's failure to verify that the rear cargo portion of the right cabin door was adequately secured before flight, which resulted in both portions of the door opening in flight and substantial damage to the fuselage.NTSB CEN19LA129Accident · No injuriesClass 3 · LimitedFinal reportPiper PA 23 · Sulphur Spring, TXThe pilot’s inadequate preflight inspection, during which he failed to detect the water contamination in the left fuel, which resulted in a partial loss of power in the left engine. Contributing to the accident was the total loss of power in the right engine…NTSB WPR19FA115Accident · 1 fatalClass 3 · FieldFinal reportBeech 60 · Fullerton, CAThe pilot’s use of an unapproved elevator control lock device, and his failure to remove that device and correctly position the elevator before flight, which resulted in a loss of control during takeoff. Contributing to the accident was his failure to perform…NTSB ERA18FA264Accident · 2 fatalField investigationFinal reportDassault Falcon 50 · Greenville, SCThe operator's decision to allow a flight in an airplane with known, unresolved maintenance discrepancies, and the flight crew's failure to properly configure the airplane in a way that would have allowed the emergency or parking brake systems to stop the…NTSB GAA18CA534Accident · No injuriesData collectionFinal reportRobinson R44 · Girdwood, AKThe fisherman's fishing rod striking the helicopter’s rotating main rotor disk during loading.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 WPR18FA143Accident · 1 fatalField investigationFinal reportI.C.A.-Brasov IS 29D · Avenal, CAThe pilot's improper installation of the wings onto the glider, which resulted in an in-flight wing separation. Contributing to the accident were the pilot's limited familiarity with the design and a lack of reliable assembly guidance.NTSB ERA18LA073Accident · No injuriesLimited investigationFinal reportAero Commander 680 F · Lapine, ALThe pilot's failure to maintain directional control during takeoff after a total loss of left engine power due to fuel contamination, which resulted in impact with trees. Contributing to the accident were the mechanic's failure to properly flush the fuel…NTSB GAA18LA062Accident · No injuriesLimited investigationFinal reportDiamond Aircraft Ind DA 40 · Mesa, AZA coyote strike and the subsequent operation of the airplane, which led to internal composite wing structure damage.NTSB CEN17FA364Accident · 2 fatalField investigationFinal reportBeech C35 · Camden, ARThe pilot's improper decision to return to the runway instead of landing straight ahead when the engine lost power and his failure to maintain adequate airspeed while maneuvering for an emergency landing, which resulted in an exceedance of the airplane's…NTSB GAA17CA529Accident · Minor injuriesData collectionFinal reportCessna 182 · Fairfield, MTThe pilot's failure to secure the right fuel cap during the preflight inspection, which resulted in fuel exhaustion, a total loss of engine power, and an off-airport hard landing.NTSB ERA17LA280Accident · 1 fatalLimited investigationFinal reportCostruzioni Aeronautiche Tecna P2004 Bravo · Quinton, VAThe flight instructor and commercial pilot's inadequate preflight inspection, which resulted in water contamination of the fuel supply, and a total loss of engine power.NTSB ANC17LA052Accident · No injuriesLimited investigationFinal reportCessna A185 · Aniak, AKThe pilot's inadequate preflight inspection, which failed to detect a crack in the propeller blade, which led to the separation of a section of a propeller blade due to fatigue.