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 20090123000209IStbros SD360 · Boston, MAWhile preparing to refuel at s.cargo the fuel truck backed into the aircraft damaging the right rear corner of the horizontal stabilizer.Accident 20090122007409APiper PA28161 · Fort Lauderdal, FLSee ptrs record SO19200916239. Student pilot was landing and was asked to land and hold short of intersecting runway. He declined stating to ATC he was a student pilot. Upon landing ATC told pilot to make the first turn off. Pilot failed to stay on the taxi…Incident 20090122002879IPiper PA32R300 · Macon, GAAbout 10 miles out, aircraft was cleared to land runway 23. During the right base leg pilot slowed the aircraft to 130 knots, and extended the landing gear. The gear did seem to extend a little slower than normal, but the two main gear green lights came on…Incident 20090122002869IDoug AD4NA · Bessemer, ALPilot landed aircraft on runway 5, the pilot applied the brakes to take the short field turn to the taxi way. The pilot stated that when he applied the brakes only the right brake grabbed, which turned the aircraft to the right and the aircraft proceeded…Accident 20090122002339ACessna 172E · Dallas, TXOn 22 January 2009 at 2139Z, a Cessna CE-172E registered as N5420T, reported an in flight engine failure. The aircraft was reported at 2000FTMSL north of addison Texas the aircraft landed on the glen eagle golf course, plano Texas approximately 1.1 miles…Accident 20090122001919AHughes 369A · Monroe, NCHelicopter N4191A, a HU-369-A, hit power lines and crashed in a field directly beneath the power lines on January 22, 2009 at approximately 10:30 am local time. The field is located just behind the central academy for technology and arts near the football…Incident 20090122001619IDonley Challengerii · Galesburg, IL(-23) While in cruise flight the aircraft's engine quit and the pilot made an emergnecy landing in a field. Upon landing the left main landing gear leg was broken off and the right main landing gear leg was bent. The aircraft struck a barbed wire fence after…Incident 20090122000519ICessna T337G · Seattle, WAOn 01/22/2009, at approximately 4:40 PST, Cessna 337 aircraft, N1ZK, landed on runway 13R on Boeing Field/King County International (kbfi) with the main landing gear not fully extended and locked down. During an ILS approach the pilot in command selected the…Incident 20090122000459ICessna 402C · Naples, FLOn January 22, 2009 hyannis air service, dba cape air (hyia), flight 9399, reported both engines lost power while enroute from key west, FL (eyw) to ft. myers, FL (rsw). Approximately 60 nautical miles south of rsw the pilot noticed an fuel imbalance of 300…Accident 20090122000419ACessna 172M · North Little R, AR(-23) On 01/22/2009, 1500 hrs aircraft N20275, CE-172M, departed VFR batesville ar (bvx) in route to benton ar (suz) with [privacy data omitted], pvt. Pilot [privacy data omitted] MEL, sel and one passenger. Received clearance to start descent from 4,500' to…Incident 20090121002889ICessna 172S · Mobile, ALStudent pilot on first solo. Upon landing, on rwy 32 at bfm, airplane drifted to left of centerline. Student applied excessive right rudder for correction. Airplane departed runway to the east (right). Nosewheel fairing was damaged.Accident 20090121002039ADickso RV8 · El Monte, CA(-23) Instructor pilot (PIC) states the follwing, "we landed and were going down the runway nice and straight, I told him he did a good job and then he made a hard left turn I said don't do that and when I saw it was still turning left I tried to correct to…Incident 20090121001759ICessna 150G · Blaine, NC(-23) At approximately 1200 hours aircraft departed buy with a mixture of avgas and auto fuel in the wing tanks. They climbed to 4500MSL and proceeded direct to lancaster, SC. The pilot stated that cruise was normal until he heard a slight increase in engine…Accident 20090121000719AUltraf Challengerii · Waldron, MOOn January 21, 2009 at 10:47, N805FA, a challenger ii cws, departed 06MO, noah’s ark airport, climbed to about 100 feet about ¾ of a mile south of the airport, executed a right turn and crashed. [privacy data omitted], The aircraft owner and prospective…Incident 20090121000469IPiper PA28180 · La Veta, COOn January 21, 2009, at approximately 1745 local time, during the cruise portion of a visual flight rules (VFR) flight from las cruces, NM (klru) to meadow lake, CO (K00V) at an altitude of approximately 13,500 feet above mean sea level (MSL), N9316J, a Piper…Incident 20090121000249IMooney M20K · Sacramento, CA(-23)On 21 January, 2009 a Mooney M20K, N231P landed at Sacramento Executive Airport. The pilot reported that the landing gear folded up as the aircraft slowed to turn off the runway. No injuries reported. The aircraft sustained minor damage to the lower…Incident 20090121000129ICessna 172S · Grand Prairie, TXOn 1/29/2009 at approx. 15:28PM a Cessna 172S, N2679M owned by [privacy data omitted], a flight school, was involved in an incident during landing due to over shooting the runway. The student pilot, [privacy data omitted], having 25 hours total time, was on a…Incident 20090120013279IHughes 369E · Atlanta, GAThis is a public aircraft. During engine shutdown, a gust of wind caused 3 of the 4 rotor blades on the aircraft to contace the upper tailboom causing substantial damage. Normal procedures were followed.Accident 20090120008559ACessna 177B · Honolulu, HI(-23) Pilot reported an engine oil leak that was spraying out and covering the cockpit windshield. Attempted to return back the phnl airport to land. Finding: the oil line from the propeller governor to the forward engine case cracked and all oil was lost.…Incident 20090120002919ICessna 172S · Fort Myers, FL(A statement by the operator/owner of this airplane is attached.) The pilot taxing to the ramp after landing with directions from the tower entered an un lit area and taxied off the edge of the ramp amd the prop hit a concret culvert.Incident 20090120002909IPiper PA31T2 · Naples, FLShortly after take off [privacy data omitted] (pilot) returned to the airport due to a smell of smoke in the aircraft. Aircraft landed without incident. Aircraft was sent to Naples jet center for maintenance, after an inspection found the number one…Incident 20090120002899ICessna 172P · Snowden, ALAircraft was being delivered on a ferry permit for annual inspection. Fuel burn was considerably higher than data supplied to pilot depicted. Pilot determined that he would not have fuel to continue, made precautionary landing on highway.Accident 20090119012479ACessna 172I · Rockford, IL(-23) Mr. John young departed from southern Wisconsin regional airport, janesville, WI (jvl) on January 19, 2009 at approximately 1545 CST. Mr. Young stated after departure the weather began to deteriorate and thus he made the decision to land at Cottonwood…Incident 20090118024979IDouglas DC-6-C118A · Atqasuk, AKPilot reported having runway 24 in sight approximately 1.2-1.5 miles out with flat light, blowing snow, and a 30 knot crosswind from 230. Pilot stated that he was sure he was lined up with the runway center line; made an uneventful touchdown and called for…Incident 20090118002929IPiper PA32RT300T · Destin, FLPilot in command forgot to extend the landing prior to touchdown.Accident 20090118002759AMaule MX7180C · Akron, AL(-23) Pilot in command elected to land on the crosswind runway. Lost control of the airplane on the landing rollout, struck windsock structure during uncontrolled ground loop.Accident 20090118002409AMulec FP404 · Hilo, HIPilot departed the Hilo int’l airport (pito) and flew toward his regular practice area south of Hilo. At 2500 feet approximately, the pilot stated that the engine quit (ceased) and that the prop stopped immediately. The aircraft does not have a starter,…Accident 20090118002049ASiemer Earthstarody · San Ynez, CA(-23) After takeoff from San Ynez Airport, while climbing, the aft cylinder, aft spark plug, departed the aircraft. This caused the engine to lose power and the failure of the front cylinder. The aircraft landed in a farm field dirt access road. The aircraft…Accident 20090118000699ACessna 172S · Emporia, KSStudent pilot was on a solo cross country flight from lawrence, KS airport (klwc) to Emporia, KS airport (kemp). Upon arriving at kemp he attempted a crosswind landing on runway 1 at Emporia airport (kemp). The pilot was not satisfied by the landing and…Accident 20090118000579ACessna 152 · Wachula, FLCessna, 152, N6566P, experianced an engine failure during climb out, climbing through 7200’. Pilot made an emergency landing off airport. During roll out the nose wheel hit a soft spot and caused the aircraft to flip over on it’s back. The two people on board…Accident 20090118000149ARyan Navion · Three Forks, MTOn 01/18/09 at 1501 LCL, aircraft N4443K, a Ryan Navion, departed gillette, WY (gcc) with full fuel and 4 soles on board bound for Three Forks, MT (9S5). The aircraft is configured with 2 aux wingtip tanks and the main tank system. The pilot switched from the…Incident 20090117002949IPiper J3C65 · Okeechobee, FLOn 01/17/2009 NC87881 a us registered aircraft struck the newly installed precision approach path indicator (PAPI) when attempting to land on the grass to the right of the active runway.Incident 20090117002939IDiamon DA20C1 · Ft Lauderdale, FLPilot called tower to request permission for priority approach to fxe airport due to a low oil pressure indication. Aircraft landed without incident. Maintenance procedures consisting of cleaning oil pressure relief valve performed, with a satisfactory…Accident 20090117002769APiper PA28180 · Jasper, GA(-23) N9459J, a Piper PA-28-180, departed ryy for jzp. When arriving at jzp, a before landing check was conducted iaw the aircraft checklist, where the fuel switch was set to the fullest tank (in this case it was moved from the right to the left tank). A…Accident 20090117001439ABeech 19A · Lafayette, IN(-23) On 01/17/2009 at approx 1905 hours N6509T piloted by a private pilot departed laf in visual meteorlogical conditions on and IFR flight plan. After departure and reaching altitude pilot contacted laf tower and reported an emergency that the prop had…Incident 20090117001319IBrubak Bearhawk · Elko, NV(-23) After landing runway 23, aircraft ground looped during roll out, and the left and right landing gear collapsed. During an inspection of the aircraft on 01/22/09, the rudder and brake system were checked for operation and no irregularities were noted by…Accident 20090117001159AQuicks SPORT2SR582 · Ventura, CAPilot-in-command was flying slow and low over the water, approximately 20 feet in altitude. As the pilot attempted a left turn his left wing hit the water forcing the aircraft to hit the water.Incident 20090117000769ISnias AS350B2 · Forrest City, AROn January 17, 2009 at 1815 central daylight time, a Eurocopter, AS350B2, registered to baptist health/baptist medical center and operated by [privacy data omitted], collided with a flock of geese 6 miles east of Forrest City, Arkansas near interstate 40,…Incident 20090117000649IBeech 58 · Lincoln, NEThe pilot landed the aircraft on runway 35 at the Lincoln municipal airport. Upon touchdown, the right main tire blew out and the aircraft veered to the right. The aircraft stopped with the right main tire 6 inches off the runway and the rest of the wheels…Accident 20090117000509ABeech A36 · Farmington, NM(-23) On January 17, 2009 at 1858 MST, the landing gear of N8074P, a Beech A36 bonanza, collapsed shortly after landing at the Farmington, new Mexico municipal airport (fmn). The aircraft was operated by mpd, inc., a large flight school in Farmington. The…Incident 20090117000259IMooney M20J · Corona, CA(-23) Pilot stated to airport mgr that he forgot to lower the landing gear. Aircraft had minor damage.Incident 20090117000119ISpackm Quickietwo · Guernsey, WYFlat tire on landing caused aircraft to go up on propeller when power was added.Incident 20090116024999IBeech 1900C · Huslia, AKPtrs#200901544 incident #IAL012008017. Captain reported upon landing in Huslia he overrotated bounced the aircraft landing with a unusually nose high attitude. Upon returning to galena when fueling the aircraft the flight crew noticed the damage to the tail…Incident 20090116002699IPiper PA23250 · Miami, FLWhile on final to tmb airport N2568M left stopped running at approximately 50 feet above the runway. Aircraft landed safely and turned off runway. The pilot noticed smoke coming from left engine, then flames. Pilot secured fuel to engines an then disembarked…Incident 20090116002139IBeech A24R · Imperial, CAImperial California (ipl) N24668 a Beech A24R, landed gear-up on Imperial County runway 32 on 01/16/2009 at approx 1630. One person on board the pilot no injuries to the pilot and minor damage to the aircraft. Aircraft removed from the runway witha fork lift.Accident 20090116001219AGlaser DG400 · Hilo, HIPilot was attempting to attain an altitude record for a glider by riding on a mountain wave. The pilot was on oxygen and last reported climbing through 28,000’ MSL. Wreckage was found over a large debris field on the side of mouna loa volcano. Strong winds of…Accident 20090116000589ANamer SNJ5 · Merritt Island, FLOn 01-16-2009, north American snj, N7861B, was landing on runway 29 at Merritt Island (coi). After touch down and during rollout the aircraft left the runway to the right and then ground looped when the pilot tried to re-establish directional control. He hit…Accident 20090116000339AJones Tailwind · Yucca Valley, CAPilot stated that upon application of the brakes (toe) the left rudder pedal broke at the base at approximately 50 mph. Aircraft ground loop at midfield runway 24. Aircraft departed the runway to the right resulting in collaspe of the left gear and left wing…Accident 20090115024869AAirbus A320214 · New York, NYAfter departing lga, and while climbing through 3,200 feet, us flight 1549 suffered multiple birdstrikes resulting in a total loss of power from both engines. The aircraft departed rwy 4 and was 7 miles north of the airport when the event occured. The flight…Incident 20090115001739IBeech 1900D · Albany, NY(-23) At approximately 1032 local time, air georgian, flt 7454, a be 1900D with a crew of 2 and 7 passengers on board, landed on runway 01 at Albany intl airport with the nr 1 engine shutdown. After landing, all 4 main tires blew and the aircraft came to a…