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 20071028832269ACessna 172M · Duluth, MN(-23) Pilot lost control of aircraft in crosswind.Incident 20071028830849IPiper PA24250 · East Troy, WI(-23) The pilot [privacy data omitted] stated as he was departing on a pleasure flight from East Troy, WI to stevens point, WI, while on the take off roll, the right wing dipped. He made a correction and continued the take off. When he retracted the landing…Accident 20071028829899APiper PA60601P · Lodi, NY(-23) At about 1327 EDT, the aircraft was on an IFR flight from kroc to danbury, CT at 5,000 feet altitude in IMC conditions and just cleared the east shore of cuyuga lake when both engines began to surge and lose power. The pilot's GPS advised that the…Accident 20071028827009ACessna 172S · Palm Springs, CA(-23) Student pilot was practicing touch-and-gos with CFI. Aircraft climbed steeply and rolled to the right. The plane came to rest inverted at the west end of rwy 28. Plane was destroyed. CFI received fatal injuries and student was transported to local…Accident 20071028826359AAmrgen AA5A · Sequim, WA(-23) The pilot was attempting to land on runway 11 at the Diamond Point airport and landed short by 15 feet on a sharp grassy incline. The aircraft bounced hard on the runway and pitched up to about a 40 degree angle. The aircraft departed the runway to the…Incident 20071028825549ICessna 172E · Knob Noster, MO(-23) N349AD a CE-172E departed on a VFR cross country from hastings, Nebraska, to sedalia, Missouri, without the appropriate fuel required to complete the flight. This resulted in fuel starvation and the subsequent loss of engine power requiring the pilot to…Accident 20071028824319ACessna T210K · Los Alamos, NM(-23) On October 28, 2007, at 1750 MDT, N8251M, a Cessna CE-210-T210K registered to the pilot, landed with the nose landing gear up and the main landing gear down at the Los Alamos Airport in las Alamos, new Mexico. The aircraft sustained substantial damage…Accident 20071028824229ABagnal KITFOXLITE2 · Skamania, WA(-23) Flying west 10' off ground over island in columbia river, into the setting sun, much glare on water, did not see boat in sun glare. On climb out saw boat and banked 20 degrees right to avoid flying over. Aircraft stalled. Pushed nose over and seemed to…Incident 20071028023409ISaab 340B · Latrobe, PA(-23) On landing, pilot reported aircraft right engine shut down over runway threshold with associated cockpit master warning. Crew continued landing sequence, and stated did not have time to declare emergency. Aircraft taxied to ramp without incident.…Accident 20071027829879ACessna 650 · Atlantic City, NJ(-23) On Saturday October 27, 2007, 11:28E, CE-650/N697MC, made a hard landing on runway 22 at Atlantic City International Airport (acy). After the hard landing the aircraft made a go-around. The aircraft lost all hydraulics, then landed on the long runway…Incident 20071027829329IPiper PA32RT300T · Millington, TN(-23) On October 27, 2007, at approximately 1030 hours CST, the pilot [privacy data omitted] was flying in the pattern at Millington regional airport (nqa) performing a shakedown flight following the completion of an annual inspection done on October 22,…Incident 20071027827359IMooney M20F · Buckeye, AZ(-23) Pilot forgot to lower the gear on landing. He did hear the gear horn but thought it was the stall warning horn. Pilot stated he did not use a landing checklist.Accident 20071027827169ABeech F35 · San Carlos, CA(-23) Aircraft departed San Carlos, CA at approximately 1100 hours with a destination of hayward, CA. However, at about 1115 hours the pilot stated the engine quit. He made several attempts to restart the engine but it failed to start, therefore, he decided…Incident 20071027826649IPiper PA18A150 · Anchorage, AK(-23) Pilot stated on phone interview and later on signed statement that he was on his third touch and go at lake Hood gravel strip. Aircraft was empty with no pax and no cargo, brakes were pumped up firm from previous flying in aleutain chain. Upon landing…Incident 20071027825479IBeech 76 · Fort Pierce, FL(-23) On October 27, 2007 at 2315 EDT, a Beechcraft B-76, N3865U, registered to ari ben aviator departed Fort Pierce, FL airport (kfpr) destination tallahassee, Florida. Approximately 15 to 20 minutes into the flight the left engine alternator failed, and the…Incident 20071027824749IPiper PA32R301 · Sedalia, MO(-23) While at cruise altitude near whiteman air force base, the pilot noticed electrical problems preceded by flickering radio equipment. The pilot stated that he was able to cancel his IFR flight plan before experiencing complete electrical failure. He…Accident 20071027824309APiper PA28181 · Boynton Beach, FL(-23) 10/27/07 - Around 20:12 local time, pilot called west palm Beach tower (pbi) and stated aircraft lost engine power. Aircraft hit multiple trees before impacting the golf course at quail ridge country club.Accident 20071026826969ABeech A36 · Camarillo, CA(-23) Camarillo act advised the pilot to go around because there was insignificant runway to land. Aircraft contacted runway 26 between taxiway e and d with gear and flaps up. The aircraft slid off the end and to the right of runway 26.Incident 20071026826269IConaer LA4200 · Lakeville, MA(-23) On October 26, 2007, at approximately 1600 eastern standard time (EST), a lake LA-4-200, N84PF being flown by the pilot [privacy data omitted] failed to control his amphibious aircraft during water landing phase. The aircraft sustained minor damage. The…Incident 20071026825539IBeech 1900D · Springfield, MO(-23) The cabin door annunciator illuminated in flight. The door did not come open. The flight was diverted to sgf and an emergency was declared. Aircraft landed safely, with the door remaining closed. It was an indication problem only.Accident 20071026824209APiper PA28R200 · Cedar City, UT(-23) The aircraft departed bountiful, Utah at 1716 MDT on a VFR flight to Colorado city, Arizona. The pilot did not have an instrument rating. At 1830 MDT a position report was made by cell phone reporting over meadow, Utah with an estimated time of arrival…Accident 20071026023789ASphrth VENTUSB166 · Salida, CO(-23) Aircraft accident site examination indicated that pilot may have entered a low speed stall/spin at low altitude. Wreckage indicated a low speed, near vertical impact with the ground. Aircraft flight control surfaces were accounted for and all flight…Accident 20071026023029ACessna 172R · Stillwater, OK(-23) The pilot and sole occupant of the airplane, [privacy data omitted] stated that he was attempting to land at the Stillwater Regional Airport, but he was too fast, and after bouncing several times he pushed forward on the controls and suffered a prop…Incident 20071025829359ICndair CL6002B19 · Salt Lake City, UT(-23) On approach to Salt Lake City, skywest airlines flight 3953 suffered a bird strike to the right wingtip area resulting in damage to the right winglet leading edge and the right navigation light assembly.Incident 20071025828669ICessna 152 · Orlando, FL(-23) Pilot on first solo flight landed on runway 9C, misunderstood tower instructions to turn right at first taxiway, turned off runway at excessive speed and failed to negotiate the turn, left the pavement and struck a taxiway sign at taxiway papa. The…Accident 20071025827959APiper PA28140 · Fresno, CA(-23) The aircraft was on final approach to runway 30 at Fresno Chandler airport when it hit a tree followed by a power pole approximately 400' short of the runway slightly left of centerline. Vfr/night time conditions prevailed (no adverse winds reported).…Accident 20071025827479ABell 206L1 · Ramona, CA(-23) Helicopter was on a damage evaluation flight over the west Ramona area following the California wild fires. Pilot and 3 utility company observers were flying relatively low and slow altitudes and attitudes to determine which fire damaged power poles…Accident 20071025826949ANorwn APACHE* · Tracy, CA(-23) Pilot took off from 1Q4 in an unregistered aircraft sometime after sundown. Airplane descended into an almond orchard about 8 nautical miles east-southeast of Tracy, CA at an undetermined time between 2000 and 2400 hours. Wreckage indicates nose impact…Accident 20071025824699AAmtr CH701 · Owosso, MI(-23) Pilot initiated take-off on runway 10 with left and right fuel shut-off valves in the off position. At approximately 30 feet above runway engine quit. Aircraft landed hard on runway approximately 380 feet from departure end, nose wheel axle sheared and…Accident 20071025022979AAmtr Searey · Napa, CA(-23) Pilot stated that he was demonstrating his airplane to another sports pilot. He came in for landing on Lake Berryessa and possibly hit something in the water as he lost control of the airplane. The airplane came to rest upside down. He is sure that the…Incident 20071024831029ISaab 340B · Detroit, MI(-23) Mesaba flt 3100 departed dtw and upon arrival at tol, the right hand outboard wheel and tire assembly was determined to be missing. Mesaba believes the wheel departed the aircraft on departure from dtw. Wheel and tire assembly has not been located.Incident 20071024830879IRaythn 400ARAYTHEON · Detroit, MI(-23) Pilot taxied aircraft with ground power cart still attached. Structural damage from event was nominal and was given special flight permit to complete repairs.Accident 20071024828089ARobsin R44 · Catarina, TX(-23) On October 24, 2007, at approximately 1345 CST, a Robinson R44 helicopter, N744RG, sustained substantial damage upon landing after the helicopter began to rock fore and aft causing the pilot to lose control. Neither the pilot nor the three passengers…Incident 20071024827279IMooney M20J · Van Nuys, CA(-23) On 10/24/2007 aircraft N5631X was flying from santa ana (sna), CA to Van Nuys (vny), CA. At approximately 0601 am, the pilot of aircraft N5631X performed a gear-up landing on runway 34L at Van Nuys Airport (vny). The pilot and two passengers exited the…Incident 20071024826909IIndusa T211THORPEDO · Sweetwater, TX(-23) After filling the aircraft with 10 gallons of fuel at the abilene regional airport (abi) in abilene, Texas, the pilot verified the fuel tank was full. The aircraft departed VFR west bound. Approximately 20 minutes into the flight the engine quit due to…Accident 20071024824559APiper PA18125 · Pilot Point, AK(-23) According to the Pilot, while landing to the east on a gravel strip near dog salmon river lodge, the wind shifted direction from a strong gusty left crosswind to a strong gusty right crosswind causing the Pilot to lose control of the aircraft. The left…Accident 20071024824549ACessna 172N · Grand Junction, CO(-23) On 10/24/07 at 1330 MDT a Cessna 172N, N1422E, landed hard at Grand Junction, CO (gjt). The private pilot and one passenger were not injured. The aircraft sustained substantial damage. The accident occurred while making a left downwind to land on runway…Accident 20071024823879ARobsin R22BETA · Long Beach, CA(-23) CFI was giving instruction to a student pilot on low RPM recovery at pad #4. CFI had previously demonstrated this procedure several times to student. Student took controls after CFI placed helicopter in a low RPM condition at approximately 8 to 10 feet…Incident 20071024023339IBeech V35B · Lincoln, CA(-23) Pilot reported he did not get a gear warning indication prior to landing. Aircraft landed with the gear in the up position. Recovery personnel noticed that the gear handle was still in the up position. When placed in down position aircraft was jacked up…Accident 20071023831269APiper PA44180 · Browerville, MN(-23) Aircraft crashed near little falls and Browerville, Minnesota and was fatal to both occupants. Circumstances to be determined by NTSB. Item 42, numbers 1 through 9 are marked no but will be updated once the NTSB concludes its investigation or…Incident 20071023831169IBoeing 747212B · Chicago, IL(-23) Kalitta air flight number 15467 departed anc at 1609Z with a normal take off and noted the anti skid light on during t/o roll. Neither crew noted any discrepancies with landing gear warning or unsafe gear door lights during flight number 15467. N703CK…Accident 20071023830129AAmrgen AA5 · Wheatland, WY(-23) Pilot was assisting cattle gathering operations and attempted to land on two track muddy road. Left main landing gear hung up in mud and caused pilot to lose control of aircraft.Accident 20071023827089APiper PA18150 · Big Lake, AK(-23) According to the pilot, while attempting a landing on a snow covered field, the wheels of the aircraft broke through a thin snow crust layer. This rapid deceleration caused the aircraft to flip over onto its back.Incident 20071023824849IBeech K35 · Olathe, KS(-23) Pilot stated that on the landing roll, after completing an ILS approach to runway 36 at Johnson County Executive Airport, Olathe, KS (ofc), the right wing began dropping to the runway. All three landing gear then collapsed, causing damage to the…Incident 20071023824409ICessna 421B · Wenatchee, WA(-23) Pilot reported that sun was in eyes and he removed sun glasses to check for three greens and is not sure if gear collapsed or if landing gear was not down. No injuries. Investigation shows gear was not down.Accident 20071023824259ATcrafk DCO65TCRAFT · Fort Myers, FL(-23) On October 23, 2007, at 10:48 EDT, a Taylorcraft, N52730, registered to the pilot [privacy data omitted] collided with automobiles in the parking lot of the edison mall while making an emergency landing at ft. Myers, Florida, while on a pleasure flight.…Incident 20071023023199ICessna 152 · Stillwater, OK(-23) Aircraft experienced a partial power loss while conducting a local training flight. Instructor performed an emergency landing in a field which was accomplished successfully. School performed an engine inspection (see attached) and discovered the exhaust…Incident 20071022831999IPiper PA28140 · Vicery, OH(-23) Pilot stated he lost control at landing and wing got caught on tall corn stalks which pulled him into corn field. Pilot then flew damaged plane to freemont airport 14G.Incident 20071022830949IAirbus A320211 · Fargo, ND(-23) At approximately 1907 CDT northwest flight 1432, a normal passenger flight from msp to FAR was landing on runway 18. The crew had received several fault notices from the aircraft prior to landing and had reset the nose gear steering system a couple of…Incident 20071022830059IAmtr Velocityxl · Saratoga Sprin, NY(-23) Upon landing on runway 14 at 5B2, the left main tire blew out causing the aircraft to leave the runway to the left onto the grass, crossing runway 5-23 coming to rest along rwy 5-23 facing north. The left main landing gear leg had cracked during the…