NTSB investigations
1,399 cases where NTSB found Use of equip/system.
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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '02063015')) 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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '02063015')) 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 ANC25LA112Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Yakataga, AKThe total loss of engine power due to carburetor icing and the pilot’s failure to effectively use carburetor heat in meteorological conditions conducive to the formation of carburetor icing.NTSB WPR25LA306Accident · No injuriesClass 4 · LimitedFinal reportTemco GC-1B · Toledo, WAThe pilot’s failure to maintain control of the airplane during takeoff in crosswind conditions..NTSB CEN25LA380Accident · Minor injuriesClass 4 · LimitedFinal reportBell 407 · Decatur, TXThe instructor candidate’s erroneous operation of the throttle during an autorotation from altitude with power recovery, which resulted in a hard landing.NTSB WPR25LA308Accident · Serious injuriesClass 4 · LimitedFinal reportThomas Graham Teenie Two · Chehalis, WAThe pilot's improper decision to take off with the airplane over its maximum allowable gross weight, which degraded its climb performance and led to a subsequent off airport landing.NTSB CEN25LA371Accident · No injuriesClass 4 · LimitedFinal reportCessna 560 · Dallas, TXThe pilot's failure to extend the landing gear before landing.NTSB CEN25LA356Accident · Serious injuriesClass 3 · LimitedFinal reportSikorsky S-76 · Round Mountain, TXThe flight crew’s failure to properly identify the heliport in dark night conditions, which resulted in the flight crew attempting to land and a subsequent impact with trees and terrain.NTSB CEN25LA355Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172M · Lubbock, TXThe pilot’s mismanagement of available fuel, which resulted in a loss of engine power due to fuel starvation.NTSB CEN25LA347Accident · Minor injuriesClass 4 · LimitedFinal reportBeech C35 · Lakeview, TXThe pilot’s fuel system mismanagement which resulted in a loss of engine power due to fuel starvation.NTSB CEN25LA342Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR22 · Granbury, TXThe pilot’s inadequate fuel management, which resulted in a total loss of engine power due to fuel starvation.NTSB ERA25LA343Accident · No injuriesClass 4 · LimitedFinal reportBeech 95-B55 (T42A) · St. Petersburg, FLThe pilot’s failure to extend the landing gear prior to landing. Contributing to the accident was a malfunction of the landing gear’s electrical retraction/extension system, which tripped the circuit breaker.NTSB GAA25WA241Accident · No injuriesClass 5 · ForeignMooney M20M · Innsbruck, AustriaNTSB CEN25LA319Accident · No injuriesClass 4 · LimitedFinal reportBeech S35 · Lowell, MIThe pilot’s failure to extend the landing gear before landing.NTSB WPR25LA237Accident · No injuriesClass 4 · LimitedFinal reportCessna R182 · Thermal, CAThe pilot's failure to extend the landing gear during landing. Contributing to the accident was the pilot’s failure to use a pre-landing checklist.NTSB ANC25LA078Accident · No injuriesClass 4 · LimitedFinal reportCessna U206C · Gulkana, AKThe pilot’s inadequate fuel management, which resulted in a total loss of engine power due to fuel starvation.NTSB WPR25LA227Accident · Minor injuriesClass 4 · LimitedFinal reportHartline J Bon Hartline Kitfox III · Logan, UTThe pilot’s failure to maintain airplane control during takeoff in variable wind and high density altitude conditions.NTSB CEN25LA290Accident · No injuriesClass 4 · LimitedFinal reportCessna R182 · Lansing, ILThe pilot's failure to extend the landing gear before landing due to his distraction of other traffic and failure to follow his landing procedures.NTSB ERA25LA274Accident · No injuriesClass 4 · LimitedFinal reportCessna TP206C · Versailles, KYThe pilot’s mismanagement of the airplane’s available fuel supply, which resulted in fuel starvation and a subsequent total loss of engine power.NTSB WPR25LA231Accident · No injuriesClass 4 · LimitedFinal reportGary Weaver CCK-1865 · Wahsatch, UTThe pilot’s inability to maintain directional control following a collision with a boulder during an off airport precautionary landing.NTSB CEN25LA243Accident · Serious injuriesClass 4 · LimitedFinal reportStinson 108 · Seguin, TXThe pilot’s failure to turn off the magneto switch before repositioning the propeller by hand which resulted in an inadvertent engine start.NTSB ANC25LA062Accident · No injuriesClass 4 · LimitedFinal reportChampion 7ECA · Wasilla, AKThe pilot’s excessive use of brakes during landing roll, which resulted in a nose-over.NTSB WPR25LA198Accident · No injuriesClass 4 · LimitedFinal reportRepublic RC-3 · Coolin, IDThe pilot’s failure to maintain control of the airplane and exceedance of the critical angle of attack during takeoff in windy conditions which resulted in a subsequent hard landing.NTSB WPR25LA189Accident · No injuriesClass 4 · LimitedFinal reportAmerican Eurocopter AS350B3 · San Luis, AZThe pilot receiving instruction’s failure to properly recover the helicopter during an autorotative landing and the instructor pilot’s failure to intervene, which resulted in a hard landing.NTSB ERA25LA262Accident · No injuriesClass 4 · LimitedFinal reportRaytheon G58 · East Hampton, NYThe pilot’s failure to extend the landing gear before landing due to his distraction.NTSB CEN25LA220Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-24-260 · Ashland, WIThe pilot’s failure to extend the landing gear before landing and his failure to conduct the before landing checklist.NTSB WPR25LA183Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-32RT-300T · Winchester, IDThe pilot’s improper fuel management resulting in fuel starvation, a total loss of engine power, and a subsequent off-airport forced landing. Contributing to the accident was the pilot’s reduced fuel level monitoring due to an inflight distraction.NTSB WPR25LA175Accident · No injuriesClass 3 · LimitedFinal reportCessna 182P · Hyampom, CAThe pilot’s failure to use carburetor heat, which resulted in a loss of engine power due to carburetor icing and a subsequent impact with terrain during a forced landing.NTSB ERA25LA226Accident · Serious injuriesClass 3 · LimitedFinal reportBeech A36 · Murfreesboro, TNThe pilot’s mismanagement of available fuel, which resulted in fuel starvation and a subsequent loss of total engine power.NTSB CEN25LA199Accident · No injuriesClass 4 · LimitedFinal reportCessna 182P · Mineral Wells, TXThe pilot’s improper fuel tank selection prior to takeoff, which resulted in a total loss of engine power due to fuel starvation. Contributing to the accident was the pilot’s failure to follow the airplane checklist.NTSB CEN25LA201Accident · No injuriesClass 4 · LimitedFinal reportLancair 235 · Pawhuska, OKThe pilot’s failure to properly configure the airplane for landing.NTSB CEN25LA179Accident · No injuriesClass 4 · LimitedFinal reportCessna 177RG · Wahoo, NEThe pilot’s failure to maintain clearance from an obstacle during taxi operations.NTSB ERA25LA200Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172 · Florida City, FLThe commercial pilot’s improper fuel management, which resulted in a loss of total engine power due to fuel starvation.NTSB WPR25LA131Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-32-260 · Green Valley, AZThe pilot's improper fuel management, which resulted in a total loss of engine power due to fuel starvation.NTSB ERA25LA182Accident · Minor injuriesClass 4 · LimitedFinal reportRobb Aventura II · Elmore, ALThe pilot’s failure to configure the airplane for a water landing.NTSB ERA25LA207Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Winter Haven, FLThe pilot’s inadvertent movement of the fuel selector to a position that restricted fuel flow to the engine, which resulted in the loss of engine power during takeoff.NTSB ANC25LA026Accident · No injuriesClass 3 · LimitedFinal reportAeronca 7CCM · Kenai, AKA total loss of engine power due to carburetor icing as a result of the pilot’s inadequate use of carburetor heat.NTSB ERA25LA142Accident · No injuriesClass 3 · LimitedFinal reportCessna TU206G · Wedgefield, FLA total loss of engine power as a result of an excessively rich fuel-to-air ratio due to the pilot’s failure to properly lean the engine’s fuel air mixture and the inadvertent activation of the auxiliary fuel pump.NTSB ERA25LA135Accident · Minor injuriesClass 4 · LimitedFinal reportIcon A5 · Smithville, TNThe pilot’s failure to retract the landing gear prior to landing in water. Contributing to the accident was the pilot’s failure to use the manufacturer’s provided checklist.NTSB WPR25FA090Accident · No injuriesClass 3 · FieldFinal reportBeech B24R · Skull Valley, UTThe flight instructor’s improper fuel management, which resulted in fuel starvation and a total loss of engine power. Contributing to the accident were multiple distractions that diverted the flight instructor’s attention from the proper monitoring and…NTSB WPR25LA092Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-235 · Shafter, CAA total loss of engine power due to carburetor ice. Contributing was the student pilot and flight instructors’ failure to utilize carburetor heat.NTSB ANC25LA017Accident · No injuriesClass 3 · LimitedFinal reportCessna 182F · Anchorage, AKThe pilot’s inadequate fuel planning, which resulted in fuel starvation and a total loss of engine power.NTSB WPR25LA089Accident · Serious injuriesClass 4 · LimitedFinal reportLockheed C-130A · Daggett, CAAn inflight upset due to an improperly secured load that resulted in serious injuries.NTSB CEN25LA087Accident · No injuriesClass 4 · LimitedFinal reportEpic E1000 · Arcola, TXThe pilot’s failure to extend the airplane’s landing gear before landing.NTSB CEN25LA081Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-24-250 · Bentonville, ARThe pilots’ mismanagement of the available fuel, which resulted in a loss of engine power due to fuel starvation.NTSB CEN25LA078Accident · No injuriesClass 4 · LimitedFinal reportZenith Stol CH750 · Byron, ILThe pilot inadvertently moved the ignition key to the off position and broke the key, which resulted in a loss of engine power and subsequent forced landing.NTSB CEN25LA072Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 182H · Harvard, ILThe pilot’s failure to control the airplane during the engine start which resulted in a collision with the hangar.NTSB WPR25LA073AccidentClass 4 · LimitedFinal reportCessna 150D · Temple City, CAThe flight instructor’s unfamiliarity with the fuel quantities the fuel measuring dip stick measured and inadequate preflight inspection which resulted in fuel exhaustion.NTSB ERA25LA094Accident · No injuriesClass 4 · LimitedFinal reportBeech 58 · Florence, SCThe pilot’s failure to follow the emergency procedures and extend the landing gear manually after the landing gear did not initially extend normally.NTSB ANC25LA013Accident · No injuriesClass 3 · LimitedFinal reportCessna 182B · Waimea, HIThe pilot’s inadequate monitoring of the fuel status while en route, which resulted in a total loss of engine power due to fuel starvation.NTSB WPR25LA069Accident · No injuriesClass 4 · LimitedFinal reportSling Sling LSA · Carson, CAThe pilot’s decision to conduct a prolonged slip against warnings specified in the Pilot’s Operating Handbook which resulted in a total loss of engine power due to fuel starvation.NTSB DCA25LA065Accident · Serious injuriesClass 3 · LimitedFinal reportUvify IFO · Orlando, FLThe remote pilot-in-command’s (RPIC’s) failure to locate the drone show center position over the physical location of the sUA, which resulted in multiple sUA colliding during the initial lift and subsequent loss of control. Contributing to the accident was…