FAA incident reports
234,323 FAA reports of aviation accidents and incidents, from the FAA’s Accident/Incident Data System (AIDS) through its Aviation Safety Information Portal. An incident falls short of an accident: a bird strike, say, or a gear-up landing without substantial damage. The NTSB investigates accidents separately, and its record of an accident is the fuller one.
Reports, newest first
Query with SQL
duckdb -csv -c "SELECT report_number, event_date, event_type, city, state, aircraft_make, aircraft_model, aircraft_damage, fatal_injuries, n_number FROM 'https://openairdocs.org/data/latest/faa_incident_report.parquet' ORDER BY event_date DESC, report_number 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 report_number, event_date, event_type, city, state, aircraft_make, aircraft_model, aircraft_damage, fatal_injuries, n_number FROM 'https://openairdocs.org/data/latest/faa_incident_report.parquet' ORDER BY event_date DESC, report_number 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.
Incident 20170926019889IBeech 200 · Escanaba, MIOn September 26, 2017, at 1050 EDT, a Beechcraft BE-200-200, N44UF, sustained damage to the left propeller, left wing, and left landing gear when, following landing at Escanaba, MI, the aircraft deviated off of the left side of runway 9 and struck a runway…Accident 20170926019879ACessna 152 · Winder, GAPilot took off at approximately 200 ft engine stopped running. Pilot landed aircraft in a field adjacent to airport and crashed.Accident 20170925024089ACessna 172P · Barrigada, GUAircraft was on 20 minute local sightseeing flight. After take-off, proceeded to two lovers point, held for other traffic over tumon bay for @ 5 minutes, then proceeded to chamorro village on the way to camel rock. The pilot noticed sparks coming from the…Accident 20170925020909APiper PA-18-150 · Beluga, AKGusty winds blew tail up after stopping on the runway, aircraft flipped onto it's back.Accident 20170925020899ABrad J. Bates Mosquito XE285 · Odessa, FLN926KB departed from (10207 lake grove drive, Odessa, FL) for a local flight of about 40-minute, with approximately 10 gallons of 93 octane. When the pilot returned for land he spotted lake grove drive and started his descent for landing. At approximately 500…Incident 20170925011949ICub Crafters CCK1865 · Belgrade, MTOn September 25, 2017 at approximately 1559 MDT (2159Z) a Cub Crafters CCK1865 sustained minor damage to the tailwheel, right front gear strut and attach point, right wingtip and right bottom engine mount frame when the pilot lost control on landing and…Accident 20170925011579AErvin Eris E Quicksilver GT-400 · Cleburne, TXThe non-certificated owner and operator departed in the aircraft from runway 17 at Blackwood Airpark Airport (TX46). Shortly after liftoff, the aircraft engine lost power. The non-certificated pilot turned right and attempted to return to the airport runway.…Incident 20170924024469ILinn Robert Lancair IV-PROPJET · Eagle, COOn September 24, 2017 at approximately 12:15 mountain daylight time, N11AW, a Lancair iv-prop jet lost power on approach and touched down after impacting three runway lights at Eagle Colorado airport. Weather at the time was visual meteorligical…Accident 20170924021709ARobinson Helicopter R22 Beta · Santa Barbara, CAOn September 24, 2017, at Santa Barbara Municipal Airport (ksba), goleta, CA, N177SR was engaged in instructional flight over a dry pond area at ksba. The PIC was instructing the SIC in hovering maneuvers. While moving along the ground at 10-15 KTS, N177SR'S…Accident 20170924021429AEpperson Edwin R Home Built KIT FOX Model 1 · Waller, TXPilot stated that he had a clean run up of the aircraft. Took off to the south and shortly after take off he lost power between 300-400FT. Pilot stated that his only choice was to land straight ahead missing trees and a mobile home. Pilot struck a barbed wire…Incident 20170924019869IAero Vodochody L39C · Rockford, ILOn September 24, 2017, the pilot in command (PIC) of N72BT, an Aero Vodochody L39C, was accomplishing pattern work at Chicago Rockford international airport (krfd). During rollout on the full stop landing on rwy 19, the PIC discovered the loss of wheel brake…Incident 20170924019859IDehavilland DHC-8-311 · Greennsboro, NCFlight 4960 clt/lyh - diverted to gso due to NO2 oil pressure caution light illuminated and oil pressure went to zero. The engine fire caution light illuminated but there was no visible smoke or fire. Crew shut down the engine and blew both fire bottles. The…Accident 20170924019849AAerotrike Safari · Shiloh, NJWhile on base leg for landing at woodcrest farms airstrip the pilot manuvered to avoid a flock of birds. One large bird impacted a wire which provides both aircraft control and wing support. This caused a controllability issue. The pilot elected to land…Accident 20170924019839ABuschmann/Vanzee VARI-EZ · Whitpain Townsh, PAAircraft departed runway 6 at wings field (lom) and experienced problems while on climb out, with possible loss of engine power. Aircraft crashed into the side of a house after hitting trees, approximately 3/4 of a mile from the departure end of runway 24.…Incident 20170924019829ICessna 180 · Skwentna, AKFlight was conducted during rainy conditions with overcast skies. During cruise flight the engine stopped suddenly. The airman immediately turned the aircraft towards the river for an emergency landing. Aircraft landed on the river without issue. The aircraft…Incident 20170924019819IBeech 200 · Berlin, MDPilot was landing at oxb at approximately 1430 hrs. During landing the aircraft hit the right wing tip during touch down, causing damage to the right tip. Temp 75.0 °f dew point 68.0 °f humidity 79% pressure 30.04 in visibility 10.0 mi wind direction ese 5.8…Accident 20170924011469ABeech C35 · Camden, AROn September 24, 2017 at 1838 CDT, a Beechcraft C-35, N5958C, impacted the ground approximately 150 feet east of the runway while departing runway 1 at harrell field airport Camden, Arkansas. A post crash fire caused substantial damage to the aircraft. Visual…Accident 20170924011349AMcmillan Joel L Avid SW 65 · Darlington, SCThe accident occurred at a private airport in Darlington, SC airport known as hicks field. The pilot made a low pass over the 700 foot runway to evaluate the field condition. Once the pilot determined that a landing would be safe he made a go around to stay…Accident 20170923019809AMitsubishi MU-2B-40 · Ainsworth, NEOn September 23, 2017, approximately 1830 central daylight time, a Mitsubishi mu 2B-40 was found substantially damaged after colliding with terrain approximately 4 miles northeast of Ainsworth Regional Airport, fatally injuring the pilot. The private pilot…Incident 20170923019799IEdwin Stafford GN-1 Aircamper · Madisonville, KYThe pilot[privacy data omitted] of the mishap aircraft was practicing taxi and groundwork in this conventional gear aircraft and had no intent on flying. He stated that he thought as long as he had the control stick back to his belly there would be no chance…Accident 20170923019789ACessna TR182 · Thief River Fal, MNThe flight departed Thief River Falls airport (ktvf) between approximately 1230Z and 1240Z under visual flight rules with reported ceilings of overcast at 400 feet. At approximately 1241Z the aircraft was observed on radar at 2900? MSL approximately 2.95…Accident 20170923019772ARobinson Helicopter R22 Beta · Clearwater, FLThe Robinson Helicopter (R-22) that day was out practicing pattern work, on the initial departure he saw an aircraft on base to runway 16 and advised him the active runway was 34, at which time he saw the aircraft veer to the left. When on his second downwind…Incident 20170923019769IPiper PA-24-250 · San Diego, CAPilot in right seat was practicing IFR approach to okb airport, he selected gear down but did not get a green gear down light. Pilot noticed gear circuit breaker tripped, 2 attempt to reset breaker were unsuccessful. Pilot in left seat flew aircraft back to…Accident 20170923019759ASC Aerostar YAK-52W · El Cajon, CAPilot was unable to start the engine due to required charge of the pneumatic system. After requesting external servicing the pilot closed the compressed air supply valve which is a required step. This is to insure against over pressurizing of the pneumatic…Accident 20170923019742APiper PA-28R-201 · Clearwater, FLThe Robinson helicopter (R-22) that day was out practicing pattern work, on the initial departure he saw an aircraft on base to runway 16 and advised him the active runway was 34, at which time he saw the aircraft veer to the left. When on his second downwind…Accident 20170923019739AMooney M20E · Perris, CAPerris valley airport (L65) at approx. 15:30 hrs., the left main landing gear collapsed after landing on runway 33. After the collapse of gear, the aircraft veered off the runway striking a runway light. The pilot in command stated that after an uneventful…Accident 20170922024379ACessna 172S · Chino, CAThe pilot and flight instructor were inbound for landing turning base for runway 26L when a large bird hit the leading edge of the right wing of the Cessna 172S aircraft. The flight instructor immediately took the flight controls and landed the aircraft…Incident 20170922020889IAero Vodochody L-39 · Thermal, CAAt 16,500 ft. during the cruise phase of the flight the crew experienced a rapid deceleration and high vibration coming from the engine. The crew declared an emergency and landed the aircraft safely at (ktrm) Jacqueline Cochran Airport. After taxing to an…Incident 20170922020879IPiper PA-28R-200 · Ravenna, OHAirman was practicing for his flight instructor practical test. He was in the process of performing a steep spiral maneuver followed by a power off 180 degree landing at pov airport. There was traffic in the traffic pattern and an airplane holding short of…Accident 20170922020869ACessna 180A · Danbury, CTOn September 22, 2017, at approximately 10:39 am, aircraft N9624B, a Cessna 180A, serial number 32921, [privacy data omitted] [privacy data omitted], was involved in an accident at the Danbury Municipal Airport (kdxr), located in Danbury Connecticut.…Incident 20170922019719ISwift S1 · Oshkosh, WIGlider experienced a no gear landing. No injuries, minor damageIncident 20170922019639IPiper PA-28R-201 · Romeoville, IL^Mr. Pacella,^ a commercial student, observed that the landing gear circuit breaker was popped on the downwind leg for runway 20 at lewis university airport, Romeoville, Illinois (klot). He assumed his instructor pulled it for training purposes and performed…Incident 20170922019629IBombardier BD-700-1A10On September 22, 2017, N618WF initiated a departure from kmez (mena mountain municipal airport, AR) for kphf (Newport ? Williamsburg international airport, VA). After engine start up, the ?gen 1 fail? Cyan message displayed, the flight crew determined that…Accident 20170922019619AMooney M20E · Glendale, CAAircraft departed from redlands airport (krei), redlands, CA, for hollywood burbank airport (kbur), burbank, CA. Upon descent and approach into kbur, approximately 5 to 7 minutes from kbur, pilot reported an engine failure. Pilot believed the engine was still…Accident 20170922011659ACessna 172L · Perkinsville, AZN7070Q departed prc at about 1620 and flew north northeast to the verde river. Radar track shows aircraft slowing descending to elevation of the top of the canyon with last signal over the river, about 1½ mile east of accident site with river meandering east…Accident 20170921022479AGodwin Jeff E Safari · Fayetteville, NCPilot was practicing copter hovering and pedal turns on FBO ramp. During last pedal turn and landing prior to accident, copter landed hard on right rear skid with tail rotor guard either striking or nearly striking pavement before copter settled down on both…Accident 20170921021539AHencken William Pietenpol AIR Camper · Franklin, PAThe pilot stated that, "he taxied to runway 21, slowly brought the power up, using the centerline to the left as reference. The tail came up and started takeoff, I don?t remember anything until I was hanging upside down". A witness stated the aircraft bounced…Incident 20170921016729IBeech C90A · Amarillo, TXSeptember 21, 2017, at approximately 0200 local, N8287E, a Beech C90A was struck by a bird enroute from tucumcari, new Mexico to Amarillo, Texas. The aircraft was being operated on an air ambulance flight. Visual meteorological conditions prevailed at the…Incident 20170921016719ICessna 172C · Mcbain, MIPilot statement - 15-20 minutes after takeoff, the engine quit. First I checked my ipad for nearest airport. When I didn?t find one, I looked ahead and to both sides of the airplane and saw only a swamp. I turned the airplane around and saw a narrow gravel…Accident 20170921016709AThomas J Murray Kitfox Super Sport · Old Forge, NYOn September 21, 2017 at approximately 1145 local time, the pilot flying N233TD a Kitfox landed on a grass strip runway number 9 at Old Forge privately owned airport (NK26), and while on touchdown roll, the aircraft with conventional landing gear and balloon…Incident 20170921016569ICessna 172R · Albuquerque, NMOn September 21, 2017, at 0916 MST, a Cessna 172R, N606DB, registered to bode aviation inc, collided with a taxiway sign while performing a high-speed taxi, without the intent to fly, at Double Eagle II Airport, Albuquerque, NM. Visual meteorlogical…Incident 20170921011959ICessna 172A · Whitehall, MT[privacy data omitted]Pilot/mechanic was taxiing the aircraft to warm it up for an annual inspection. There was no intention of flight. Right main gear got stuck in a gopher hole. He exited the aircraft, with the engine running, to push out of the gopher…Incident 20170921011869IBellanca 17-30 · Colorado Spring, COOn 09/21/2017 at 08:35 MDT, N4888V, a Bellanca 17-30 aircraft sustained minor damage during landing on runway 17R at Colorado Springs Municipal Airport. The single pilot and single passenger on board were not injured. The weather at the time was VMC.Accident 20170921011459ACessna 180H · Albuquerque, NMOn September 21, 2017, at 1313 MST, a Cessna 180H, N180SA, registered to the pilot, departed the runway during take-off from Double Eagle II aiport, Albuquerque, new Mexico, while on a personal flight. Visual meteorological conditions prevailed at the time,…Accident 20170920021779ARobinson Helicopter R22 Beta · Long Beach, CAOn September 20, 2017, at approximately 1309 PST (pacific standard time), a Robinson R-22, U.S. Registered helicopter, N7514S was substantially damaged when it rolled over on its side while attempting to land at pad three, at Long Beach airport (lbg) Long…Accident 20170920020859ACessna T210L · St. George, UTPilot stated landed aircraft gear up and failing to engage the gear. Pilot stated took aircraft for flight test following annual inspection. Stated traffic in pattern in process stated he out of his usual routine. Pilot stated gear did not get extended. He…Accident 20170920020849ACessna 150E · Siler City, NCAircraft had intermittent generator on a time-building cross-country flight in VMC conditions. Generator and battery eventually died and pilot was unable to get a reading on his fuel gauges. Pilot stopped at scr (Siler City, NC, formerly 5W8) to take manual…Incident 20170920019609ICessna 172P · Sanford, FLN52747 was cleard to land on runway 9R. During roll out the aircraft was observed departing the runway to the north side hitting a runway edge light.Incident 20170920019599IBeech 99Pilot indiacted the flight began as a normal departure out of manchester, NH in N193WA under wiggins 1046. Upon arrival to the final approach fix in presque isle, pilot checked the airspeed and selected the gear handle to the down position. There was no…Incident 20170920012129ICessna R182 · Decatur, AL09/20/2017 - N4894T, a Cessna R-182, was conducting approaches to dcu. While attempting a zero flap landing the aircraft made contact with the runway due to the landing gear not being down and locked. During the conversation with the pilot and by admission in…