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.
Accident 20100119027289ALuscombe 8A · Madison, GAAccording to the pilot, Mr. Leithead, he was on a VFR flight in N2750K from monticello sky ranch airport (GA06) to Madison Municipal Airport (52A) on January 19, 2010. He entered a left hand pattern for rwy 14 and observed the windsock was down. His approach…Incident 20100119027069IBombardier CL-600-2B19 · Charleston, WVCaptain stated that take off data (v speeds) were predicated on a flaps 20 degree setting for take off. The captain further stated the flaps were inadvertently and incorrectly set to 8 degrees. During the take off roll the captain noticed the flaps were set…Incident 20100119026219ICessna 150F · Okeechobee, FLOn January 19, 2010, while on the return leg of a cross-country flight from sarasota-bradenton international airport (srq) to witham filed airport in stuart Florida (sua), the aircraft ran out of fuel and made an emergency landing in a field five to seven…Accident 20100119026049ACessna 172M · Bethel, AKThe aircraft was attempting a soft-field takeoff using rwy 1L at the Bethel Airport when the aircraft yawed and banked violently to the left just as the nose wheel started to rise slightly. The aircraft veered 90 degrees and continued into the grassy section…Accident 20100119026029ABeech B200 · Sioux City, IAAircraft was cleared to land on runway 31 at 0710 local time. Aircraft touched down at 0714 local time. At that point tower could not contact by radio. The airport was fogged in enough that the tower operator could not see the aircraft. At 0716 local time,…Incident 20100119026019ICessna 402B · Valentine, NEN3796C, Cessna 402B, was operated as DKT1576 by business aviation courier inc dba encore air cargo. The aircraft was enroute from sioux falls, south dakota to Valentine, NE when the left engine lost power. The pilot landed safely at Valentine. Maintenance…Incident 20100119025979IBell 407 · Appomattox, VA01/19/10; 1345 EST: police helicopter made precautionary landing near Appomattox, VA, for safety concerns. Upon landing, pilot discovered bullet holes in fuselage, rotor blade, and fuel tank.Accident 20100118027359ALuscombe 8A · Springfield, TNThis was the student pilot's first solo flight. On his first attempt at landing, the aircraft bounced three times on runway 22. After the third bounce, witnesses say that the aircraft pivoted to the left about 45 degrees from its longitudinal axis. Witnesses…Incident 20100118026799ILydon Patri Searey · Sanford, FLThe aircraft, a Searey amphibian plane was on local flights completing touch & gos and full stop landings between lake dora, leesburg & mid Florida without incident. On return at 1000 ft, east towards Sanford where based, the pilot proceeded with clearance to…Accident 20100118026779ABeech B-60 · Huntsville, ALThis flight was on an IFR flight plan in VMC. About thirty miles north of the departure airport, hsv and about sixty eight hundred (6,800) feet the right engine sustained a catastrophic failure. The pilot elected to return to hsv. Witnesses stated that the…Accident 20100118026329AMitsubishi MU-2B-60 · Elyria, OHThe pilot aborted the first approach to runway 7 at Lorain County Regional Airport (lpr), located at Elyria, Ohio,the pilot completed a go-around and attempted a 2nd approach that ended in the aircraft crashing short and slightly left of runway 7 into a muddy…Accident 20100118026199ACessna 340 · Lydle Creek, CAOn 01/18/2010 at approximately 2103 zulu time a Cessna 340, N2217B, departed henderson airport (hnd), henderson, NV enroute to compton airport (cpm), compton, CA. The Cessna 340, N2217B, was owned and piloted by a private pilot with airplane single and…Accident 20100118026169ACessna 172M · Palm Springs, CAN13073, Cessna C172, at 6000 feet, contacted sct for flight following 9.5 miles northeast of Palm Springs at 180822PST. A beacon code was issued and acknowledged but there was no radar identification or further radio contact with aircraft. 2 occupants,…Accident 20100118025989AEurocopter AS 350 B2 · Nyc, NYDuring a descent to landing the pilot felt a vibration developing in the helicopters anti-torque pedals , cyclic control and airframe. Upon landing the pilot rolled off the throttle to flight idle and the vibrations worsened until the main rotor stopped. A…Incident 20100118001829ICessna A185F · Orlando, FLThe aircraft, a searey amphibian plane was on local flights completing touch & gos and full stop landings between lake dora, leesburg & mid Florida without incident. On return at 1000 ft, east towards Sanford where based, the pilot proceeded with clearance to…Accident 20100117027132ABuckeye Avi DM 582 · Sublette, KSOn January 17, 2010 at 1730 two n registered powered parachute aircraft collided in mid air 17 NM northwest of Sublette, KS. The two aircraft were flown in close proximity to one another with the pilot of the lead aircraft ahead and above the trailing…Incident 20100117026899IBell 206B · Wright, WYPilot picked up a load with long line helicopter and was transporting to drop location. Pilot was paralleling power lines and did not see a power line running 90 degrees from the power line he was following. Struck the power line with the load and tore the…Accident 20100117026729AMooney M20R · La Veta, COWhile making a 180 turn on the runway in preparation for takeoff of runway 6 the pilot heard a muffled "pop" sound when he advanced the throttle followed by seeing a puff of smoke. Pilot shut down the engine climbed out of the airplane and noticed flames…Incident 20100117026429IBombardier CL-600-2B19 · Detroit, MIDuring pushback from the gate, the aircraft was pushed into a baggage cart. The cart struck the airplane between the left outboard and inboard flaps. It also struck the fuselage forward of the aft baggage door. The cart was pushed approximately 80 ft. the…Accident 20100117026339AEurocopter AS 350 B3 · Reno, NVAn investigation subsequent to a hard landing after a loss of power to the main rotor system revealed the three (3) engine to m.g.b. coupling shaft (p/n 350A35-110-21) attach nuts (p/n ASNA044-080BCL) unthreaded from the three (3) (p/n 350A32-1060-38) screws…Accident 20100117026309ACessna P172D · Cedar Rapids, IAThe pilot was single engine visual flight rules (VFR) rated. The pilot received a weather briefing from flight service at 0830 local and departed on a VFR flight from tulsa ok (krvs) for Washington IA (kawg) at 1609 local on 01/17/2010. The pilot planned to…Accident 20100117026159ACessna 182R · Philomath, OROn January 18, 2010, at approximately 1700, Cessna 182 operated by the us department of the interior, as a public use aircraft, departed newport, OR (konp) enroute to corvallis (kcvo). The aircraft crashed into heavily wooded, mountainous terrain…Accident 20100117026149ACessna 172N · Mannlius Townsh, MISunday, January 17, 2010, david otai arrived at Tulip City Airport at 8AM with a female passenger. He was given the keys and documents for the aircraft after his certificate file was verified. Mr. Otai decided not to fly right away due to the weather and…Accident 20100117026112ABuckeye Avi DM 582 · Sublette, KSOn January 17, 2010 at 1730 two n registered powered parachute aircraft collided in mid air 17 NM northwest of Sublette, KS. The two aircraft were flown in close proximity to one another with the pilot of the lead aircraft ahead and above the trailing…Accident 20100116026299ACessna 177RG · Cedar Rapids, IAThe pilot received his instrument rating 2 weeks prior to the accident. The pilot received a weather breifing from flight service just prior to departure from batavia, Ohio (I69) with a destination of monticello, IA (mxo). The pilot deviated to Cedar Rapids,…Accident 20100115028109ASteele Samu RV-4 · Picayune, MSThe pilot/a&p/owner, was working on the auto pilot, on the day of the accident. The pilot took a passenger for the test flight, of the auto pilot. A witness observed the plane 1,600 feet from the end of the runway, doing a flyby at about 50 feet AGL. The…Accident 20100115027959ACirrus Desi SR22 · Fredericksburg, TXAfter a cross country flight of 167 miles, the pilot attempted to land at T82, runway 32, in the dark with winds that had gust projected up to 18 KTS (for that time frame). During touchdown he noted the aircraft drifting left, he attempted to stay on the…Incident 20100115026412ICessna 172F · Jasper, GAOn Friday, January 15, 2010 Mr. Ward, the pilot, was unable to start N5588R, a Cessna 172F, with the key. Mr. Ward chose to hand prop the airplane. With the throttle and parking brake set, master and key off, he pulled the prop through six times and then…Incident 20100115026389IPiper PA-18-150 · Staten Island, NYOn 15 January 2010, at 1050 hours (hrs.) Eastern standard time (EST) N4615Y a 1972 Piper PA-18, serial # 18-8936, owned by smoketown banners LLC, of 110 short st. new holland, PA. 17557 and piloted by dan milligan, commercial pilots license 3117448, departed…Incident 20100115026129IPiper PA-28-161 · Crescent City, FLDuring flight, at approximately 1000 feet altitude, Mr. Simon davis, the pilot in command heard a loud bang and notices an immediate lost of engine power output. He executed an emergency landing in a field at the following coordinate, latitude 29º. 29. 31,…Incident 20100114027099IPiper PA-28R-201 · Bowling Green, OHWhile performing a touch-and-go landing, the PIC allowed the student to retract the landing gear mistakenly instead of the flaps. The aircraft's right main gear collapsed causing the aircraft to turn right and leave the runway surface.Accident 20100114026809APiper PA-28-140 · Collegedale, TNDeparted runway 3 prior to sunrise and impacted trees to left of the centerline approximately 80 yards from the airport safety area. Pilot stated he fixated on the airspeed indicator, failed to scan the other instruments and the atitude indicator. He stated…Incident 20100114026069IBoeing 737-3TON732VA, a B737-300, part of the initial haiti disaster relief effort carrying fema workers from atlanta to port au prince haiti was given priority descent after an extended ATC delay at FL290 over Toussaint Louverture int (mtpp) for fuel critical handling.…Accident 20100114025969AErcoupe 415-D · Napa, CAAircraft N2332H, Ercoupe 415D departed Napa county airport (apc) on runway 36 at approximately 1430 hrs on 1/14/2010. At approximately 100 feet AGL the aircraft experienced an engine RPM surge of 50 to 100 RPM. The aircraft continued to climb when at 200 feet…Accident 20100114025939APiper PA-12 · Glenallen, AKAircraft landed on frozen lake, during taxi the right landing gear struck a unforseen snow covered snow bank damaging the right gear attachment point.Accident 20100113027059ACessna 140A · Urbana, ILPilot lost control during landing in a tailwheel aircraft. Aircraft departed the runway, struck a snow bank and flipped over causing substantial damage. The pilot and one passenger received no injuries.Accident 20100113026189AFoster John Glasair III · Oxford, CTPilot impacted steel cable over high tension wires 1/4 mi short of the approach end of runway 36 at oxc airport. Aircraft impacted the ground and bounced 144 feet to impact an electrical sub-station.Incident 20100113026039ICessna 210C · Bay St. Louis, MSDuring a touch and go landing at stennis international airport (khsa) on runway 18, the pilot reported that as the flaps were being moved to the takeoff position and power being advanced for takeoff the nose landing gear collapse.Incident 20100113025889INanchang CH CJ-6A · Concord, CAPilot reports uneventful flight and landing. On landing roleout at approximately 28 knots indicated, the nose of the aircraft began to rise. Pilot reports no adverse indications were noted in the cockpit. The aircraft nose continued to rise with aircraft…Incident 20100112028329IRaytheon Ai 58 · Jamestown, NYAircraft touched down approximately 3500 feet from approach end of runway 25, with 1800 feet remaining. Runway 25 surface condition was thin loose snow over hard packed snow and ice.Incident 20100112026099IBoeing 737-400 · Miami, FLAt approximately 2200L, a Boeing 737-400, N728CF, struck a light pole at the southwest corner of the general aviation center (gac) ramp, bldg 841. The incident occurred after N728CF arrived at mia and was making a left turn from taxiway k to enter the gac…Incident 20100112025869IDean George Dean/Pitts · Deland, FLDuring landing rollout on runway 30 at the Deland airport, aircraft N306GD, serial number 001 flipped and came to rest in an inverted position on the grass next to the taxiway. The propeller, engine, engine cowling, wing center section, right wing tip, and…Accident 20100112025809AYoung, Dee Kitfox II · St. Anthony, IDDuring landing pilot loss control of a/c 10' off runway 4 at st Anthony, ID (U12). A/c bounced twice off centerline and veered to the left went into ice and snowbank and flipped over. A/c moved before NTSB or FAA gave permission.Incident 20100111026819IBombardier CL-600-2B19 · Atlanta, GANose wheel steering message on ground. Performed reset iaw CRJ200 fim reset procedure per maintenance control.Incident 20100111026409ICessna 172M · Troutdale, OROn January 11, 2010, at approximately 2046Z (1246L) while taxiing onto runway 07 at the Portland Troutdale airport, N5201H, a Cessna 172M aircraft, sustained a prop strike and the aircraft's right wing contacted the runway. Prior to taxiing to runway 07, the…Incident 20100111026289IBombardier CL-600-2C10 · Atlanta, GAFlight ASQ5460, CRJ7, atl-bwi, returned to atl due to unspecified maintenance problem. Aircraft landed without incident. The aircraft had a left engine bleed message.--removed and replaced acs controller returning aircraft to service iaw crj 70021-61-01 amm.Incident 20100111025849ICessna 310J · Greenville, MEOn takeoff shortly after rotation, the pilot detected an engine abnormality. He elected to land straight ahead with the wheels up on the snow and ice covered runway rather than attempt a pattern on one engine from ground effect at or below blue line.Accident 20100110026079APiper PA-32-300 · Honolulu, HIOn January 10, 2010, at approximately 13:00 HST, N8934N departed lanai city enroute to the Honolulu International Airport. ATC recording revealed that the pilot of N8934N was at times unable to see the island of oahu and was not orientated with his location.…Accident 20100110025959AEngineering Ercoupe 415 · New London, WIPilot did not obtain preflight wx brief. Windsock very worn & giving inaccurate readings. Winds were approximately 12-14 knots from 210 degrees but the worn windsock would not acquarately show this. Runway was plowed approximately half of its width so that…Incident 20100110025769IAirbus Indu A319-131 · Newark, NJNote block 5: NTSB incident number as received from the NTSB is DCA10IA021. "I" is not a choice from the drop down menu on this electronic form. After an uneventful flight from ord to ewr, crew selected gear down on final to rwy 4R at ewr. Ecam indication was…