NTSB investigations
354 cases where the sequence of events included Fire/smoke (post-impact).
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\" = '170' 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" = '170' 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 CEN22FA375Accident · 1 fatalClass 3 · FieldFinal reportSonex Waiex · Maxwell, CAA loss of control in flight for undetermined reasons that resulted in an impact with terrain.NTSB ERA22LA317Accident · No injuriesClass 3 · LimitedFinal reportCessna T210F · Monticello, NYMaintenance personnel’s improper torque of the engine through-bolts during maintenance, which resulted in a bearing shift, oil starvation, and a total loss of engine power.NTSB DCA22FA132Accident · Minor injuriesClass 2 · FieldFinal reportMcdonnell Douglas MD80 · Miami, FLThe structural failure of the left main landing gear downlock following ineffective shimmy dampening during the landing roll which caused the collapse of the left main landing gear, resulting in a runway excursion and post-flight fire.NTSB CEN22FA215Accident · 1 fatalClass 3 · FieldFinal reportGrumman American Avn. G-164 · Whiskerville, ARThe pilot misjudged the approach during the emergency landing, likely due to the full chemical load, and impacted a ditch, resulting in substantial damage and postimpact fire. Contributing to the pilot’s injuries was the lack of a crash-resistant fuel system…NTSB ERA22FA226Accident · 1 fatalClass 3 · FieldFinal reportCessna 172H · Miami, FLA total loss of engine power due to carburetor ice as a result of the pilot’s failure to effectively use carburetor heat in conditions conducive to the formation of carburetor ice.NTSB ERA22FA223Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-24-250 · Athens, GAA total loss of engine power for reasons that could not be determined based on the available information.NTSB CEN22LA163Accident · 2 fatalClass 3 · LimitedFinal reportKitfox 7 · Crowell, TXThe pilot's exceedance of the airplane's critical angle of attack during low-level flight, which resulted in an aerodynamic stall and loss of control at an altitude too low to recover.NTSB CEN22LA138Accident · No injuriesClass 3 · LimitedFinal reportBeech 200 · Gulfport, MSThe failure of the right main landing gear actuator, which led to a gear-up landing.NTSB GAA22WA108Accident · Minor injuriesClass 5 · ForeignPiper PA23 · Treasure Cay, BahamasNTSB CEN22FA053Accident · 1 fatalClass 3 · FieldFinal reportBell 206 · Perry, OKA loss of lateral control during a hover that resulted in an impact with terrain. Based on the available evidence, the reason for the loss of lateral control could not be determined.NTSB ERA21FA346Accident · 4 fatalClass 2 · FieldFinal reportCessna 560 · Farmington, CTThe pilot-in-command’s failure to release the parking brake before attempting to initiate the takeoff, which produced an unexpected retarding force and airplane-nose-down pitching moment that prevented the airplane from becoming airborne within the takeoff…NTSB ERA21FA225Accident · 2 fatalClass 3 · FieldFinal reportFlight Design Ctsw · Winterville, NCThe pilot’s exceedance of the airplane’s critical angle of attack during a go-around, which resulted in an aerodynamic stall and a loss of control.NTSB ERA21LA201Accident · 1 fatalClass 3 · LimitedFinal reportBeech A36 · Lakeland, FLThe total loss of engine power for reasons that could not be determined based on the available evidence.NTSB ERA21FA154Accident · 3 fatalClass 3 · FieldFinal reportBeech B36 · Pembroke Pines, FLThe pilot’s likely activation of the auxiliary fuel pump to “high” for undetermined reasons during takeoff, which resulted in total loss of engine power due to an excessively rich fuel-to-air mixture. Also causal was the pilot’s exceedance of the airplane’s…NTSB ERA21LA080Accident · 1 fatalClass 3 · LimitedFinal reportSocata TB10 · Pembroke Pines, FLThe pilot’s failure to use carburetor heat in environmental conditions favorable for serious carburetor ice during a prolonged wait with the engine at a low power setting before takeoff, which resulted in a partial loss of engine power due to carburetor ice.…NTSB ANC20LA085Accident · 2 fatalClass 3 · LimitedFinal reportCessna A185 · Fairbanks, AKThe PA-18 pilot’s failure to see and avoid the Cessna 185 as it was landing. Contributing to the accident was the PA-18 pilot’s failure to hear the traffic advisory provided by the air traffic control tower.NTSB CEN20LA352Accident · 1 fatalClass 3 · LimitedFinal reportBeech 200 · Rockford, ILThe pilot’s failure to maintain airplane control following a reduction of thrust in the left engine during takeoff. The reason for the reduction in thrust could not be determined based on the available evidence.NTSB CEN20CA355Accident · No injuriesClass 4 · Data collectionFinal reportCessna 182 · Odessa, TXThe pilot's failure to maintain directional control of the airplane during landing.NTSB WPR20CA269Accident · Serious injuriesClass 4 · Data collectionFinal reportCessna 182 · Cascade, IDThe pilot's decision to continue the unstable approach which resulted in an inadequate flare, bounced landing and collision with trees following a delayed go around.NTSB WPR20LA228Accident · No injuriesClass 3 · LimitedFinal reportMd Helicopter 600 · San Andreas, CAThe failure of the output shaft of the overrunning clutch inner race due to frictional overheating of the shaft, which resulted from the failure of the output bearing’s stainless-steel grease seal.NTSB CEN20CA100Accident · Minor injuriesData collectionFinal reportCommander 114 · Coldwater, MIThe flight instructor’s inadequate communication with the pilot under review about his intention to simulate a single-engine failure and his subsequent exceedance of the airplane’s critical angle of attack when the pilot did not respond as expected, which…NTSB CEN20CA087Accident · No injuriesData collectionFinal reportVans RV8 · Columbus, MSThe inadvertent engine start of the unoccupied airplane, which resulted in it moving forward and impacting a hangar and an electrical box.NTSB ANC20CA012Accident · Minor injuriesClass 4 · Data collectionFinal reportCirrus SR22 · Kapolei, HIThe student pilot's loss of airplane control during a short field takeoff in gusting crosswind conditions, and the designated pilot examiner's delayed remedial action.NTSB ERA20LA062Accident · No injuriesClass 3 · LimitedFinal reportPiper PA32RT · Fletcher, NCA failure of two of the oil pump drive gear’s teeth, which resulted in a loss of engine oil lubrication, and a total loss of engine power.NTSB ERA20LA044Accident · Serious injuriesClass 3 · LimitedFinal reportBeech E35 · Okeechobee, FLThe separation of the throttle control cable from the carburetor throttle control lever resulting in the near total loss of engine power. Contributing to the separation of the throttle cable was the lack of proper securing hardware by unknown maintenance…NTSB GAA20CA088Accident · Serious injuriesData collectionFinal reportHiggins John H/Williams John D Questair Venture · Daytona Beach, FLThe pilot's unstabilized approach, which resulted in a hard, bounced landing, loss of directional control, and impact with a tree and then terrain.NTSB GAA20CA033Accident · No injuriesData collectionFinal reportWeatherly 620 · Fabens, TXThe pilot's failure to maintain clearance from power wires while maneuvering at a low altitude.NTSB GAA20CA042Accident · No injuriesData collectionFinal reportBeech 19 · Somerville, TNThe pilot's failure to move the fuel selector position to the "on" position before takeoff, which resulted in a total loss of engine power and necessitated a forced landing to a field shortly after takeoff, and his subsequent improper decision to take off…NTSB WPR19WA254Accident · No injuriesForeign investigationCessna 560 · Azligarh, IndiaOn August 27, 2019, at 0310 universal coordinated time, a Cessna 560 XL airplane, VT-AVV, collided with an electrical cable during the landing at the Aligarh Airport, Aligarh, India. The airplane was destroyed during the post crash fire. The airplane was…NTSB CEN19FA278Accident · 1 fatalField investigationFinal reportGrumman G164 · Hays, KSThe pilot's exceedance of the airplane's critical angle of attack, which resulted in an aerodynamic stall.NTSB ERA19FA248Accident · Minor injuriesField investigationFinal reportTextron 680A · Elizabethton, TNThe pilot's continuation of an unstabilized approach despite recognizing associated cues and the flight crew's decision not to initiate a go-around before touchdown, which resulted in a bounced landing, a loss of airplane control, a landing gear collapse, and…NTSB ERA19LA247Accident · 1 fatalClass 3 · LimitedFinal reportFantasy Air Allegro · Boone, NCThe reported total loss of engine power for reasons that could not be determined based on the available evidence.NTSB ANC19LA031Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 208 · Bethel, AKThe pilot’s failure to maintain adequate airspeed while maneuvering during an attempted go-around, which resulted in an exceedance of the airplane's critical angle of attack and an aerodynamic stall at low altitude. Contributing to the accident, was the…NTSB CEN19MA190Accident · 10 fatalClass 2 · MajorFinal reportTextron B-300 · Addison, TXThe pilot’s failure to maintain airplane control following a reduction of thrust in the left engine during takeoff. The reason for the reduction in thrust could not be determined. Contributing to the accident was the pilot’s failure to conduct the airplane…NTSB CEN19FA189Accident · 1 fatalField investigationFinal reportBeechcraft 58 · Hiawatha, KSThe pilot's loss of control for undetermined reasons.NTSB WPR19FA133Accident · 1 fatalClass 2 · FieldFinal reportJust JA30 Superstol · Chelan, WAThe pilot’s exceedance of the airplane's critical angle of attack during the initial climb after takeoff, which resulted in an aerodynamic stall and spin.NTSB ANC19FA018Accident · 2 fatalField investigationFinal reportBeech A60 · Santa Rosa, NMThe pilot's loss of airplane control due to his failure to maintain appropriate control inputs and airspeed after shutting down an engine because of a progressive failure of the pressure relief valve in the fuel pump, which resulted in variable fuel pressure…NTSB CEN19FA117Accident · 1 fatalClass 3 · FieldFinal reportAir Tractor AT 502 · Harlingen, TXThe pilot’s failure to maintain clearance from power transmission lines during low altitude flight operations. Contributing to the accident was the pilot’s impairment due to a sedating medication.NTSB ERA19LA138Accident · No injuriesClass 3 · LimitedFinal reportFisher Flying Products Dakota Hawk · McAlpin, FLThe pilot's failure to use carburetor heat while operating at idle power in atmospheric conditions conducive to the formation of carburetor ice, which resulted in a partial loss of engine power during takeoff.NTSB ERA19FA124Accident · 1 fatalField investigationFinal reportPiper PA31 · Madeira, OHFuel starvation to the left engine and the resulting loss of engine power to that engine, and a loss of airplane control due to the pilot's failure to maintain the minimum controllable airspeed.NTSB ERA19LA078Accident · 1 fatalLimited investigationFinal reportBRM Aero Bristell S-LSA · Lakeland, FLThe student pilot's exceedance of the airplane's critical angle of attack during the initial climb, resulting in an aerodynamic stall from which the pilot did not recover.NTSB ERA19FA060Accident · 2 fatalClass 2 · FieldFinal reportCessna 335 · Fort Lauderdale, FLThe pilot's improper decision to fly the unairworthy airplane and his failure to feather the left propeller following a partial loss of power from the left engine after takeoff. Also causal was the partial loss of power to the left engine due to detonation.NTSB CEN19FA035Accident · 1 fatalField investigationFinal reportPiper PA 30 · Marion, INThe pilot's exceedance of the airplane's critical angle of attack following a loss of the left engine power shortly after takeoff, which resulted in an aerodynamic stall at an altitude too low for recovery. Contributing to the accident was the loss of left…NTSB ANC19LA008Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Whittier, AKA total loss of engine power for reasons that could not be determined based on the available evidence.NTSB ERA19FA034Accident · 2 fatalField investigationFinal reportAutogyro Cavalon · Sebring, FLThe pilot's improper decision to operate the gyroplane in an unairworthy condition, which resulted in the cyclic pitch control disconnecting in flight. Contributing was the pilot's inability to maintain control of the helicopter utilizing the published…NTSB CEN19FA018Accident · 1 fatalField investigationFinal reportEurocopter AS350 · Odanah, WIThe pilot's loss of helicopter control for undetermined reasons.NTSB CEN18FA387Accident · 1 fatalField investigationFinal reportBeech 200 · Oscoda, MIThe pilot's descent below minimum descent altitude during the nonprecision instrument approach for reasons that could not be determined based on the available information.NTSB WPR18FA266Accident · 1 fatalClass 2 · FieldFinal reportBeech 33 · Cottonwood, AZThe pilot's mismanagement of the available fuel, which resulted in a total loss of engine power due to fuel starvation.NTSB ERA18FA232Accident · 1 fatalField investigationFinal reportPiper PA22 · Island Pond, VTThe pilot's exceedance of the airplane's critical angle of attack while maneuvering for landing, which resulted in an aerodynamic stall.NTSB CEN18LA349Accident · Serious injuriesLimited investigationFinal reportNorth American T-28B · Minneapolis, MNThe fire during approach for reasons that could not be determined based on the available evidence, which resulted in impact with terrain during approach for a precautionary landing.